I am trying to insert the following message:
friend's mobile number
from a file over redhat server into sql server 2005.
this message is appearing in the sql server as below:
friend s mobile number
where the apostrophe is appearing as a space, I tried different escape characters but still didn't work.
How can I fix this?