HELP: Embedded characters in SQL statement

[Quoted] [Quoted] I would like to know how to submit an SQL statement which has imbedded characters such as an apostrophe or quotation-mark in them. For example,

SQL_Statement="Select * from myTable where companyName = 'Wilson's Products'"

As you can see, the word Wilson's contains an embedded apostrophe.

Is there an acceptable method whereby I can submit this value without the [Quoted] apostrophe causing a problem?

[Quoted] I've tried this with Oracle via RDO and it fails on the statement because [Quoted] of the embedded apostrophe.

[Quoted] Please e-mail your solution if possible.

Thanks....

-- 
Bob
rhl_at_cadmandu.com