>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.