>Im having problems with something I never got before.
>Im building the statement to send values do SQLServer,
>but I got an erro when the values ( parameters" to be send
>has an apostrophe in it's name like "Jim's", "Sandy's" or "D'Agua".
>
>I could use STRTRAN() to get rid of the apostrophe, but
>so the name would change, and that it's not a solution for the problem.
>
>Question: Is there a way to solve this problem ??
>
>Thanks in advance
>
>Peter
You've to double single quote inside string literal.
CHRTRAN([Jim's], ['], [''])
--sb--