escaping strings

[devikacs]

My query mails because some of my data [varchar fields] contains characters like / , '
Can i do something about it?

[docdiesel]

Hi,

My query mails because some of my data [varchar fields] contains characters like / , ' Can i do something about it?

could you give an example? If you're executing the query on the shell, you'd better enclose it in double " quotes. Additionally, if there're double quotes in the query itself you've got to escape them by \" otherwise the shell will cut the query string at this place.

Regards,

Bernd