>Nick Can you please tell me the convert function for the datatype numeric to char.
>
>since my first field datatype is char and the second one is Numeric.
>
>both the fields i am trying to concatenate.
>
>
>
>Thank you very much.
See STR() function in Help. PADR(), PADL, PADC() functions also convert the numeric values to string along with padding the result as requested.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison