Thanks, I should haven know about the evaluate thing. I copied the code from somewhere else and it worked, so I didn't think about taking out the eval statement. Again thanks, you are always a very helpful person.
>Hi Rodney,
>
>You've to double single quotes inside SQL Server strings.
company_name = '" + CHRTRAN(ALLTRIM(m.company_name), ['], [''])) + "'" + ;
BTW,
EVALUATE('m.company_name')
>** is the same as
>m.company_name
red
Rodney E. Dixon
Mckee Foods Corporation
Collegedale, TN