Adding two fields together

[tbailey922]

Hello,
Does anybody know how to add two fields together in a foxpro table? What I have in one table is areacode in one field and the phonenumber in another field. I want to add these
fields together to make one field with areacode + phonenumber as one.

Thanks
Tim

 

[JRB-Bldr]

Concatenating two string fields into one single value is as simple as:

mcNewString = mcString1 + mcString2

In order to end up with a single value in your table representing the AreaCode + PhoneNumber you first have to ensure that your target field will hold enough characters.

Next you have to ensure that both source fields as in character form - or else perform the necessary number-to-character conversion within your REPLACE command.

Assuming that you have done the prior-work...

REPLACE ALL Telephone with AreaCode + PhoneNumber

should do the job.

Good Luck,
JRB-Bldr

 

[tbailey922]

Thanks for the help and reply.

Tim