Using ' character in string in where statement

Greetings,

I hope someone can help me with this maybe "stupid" question. I have looked at otn and in this newsgroup but cant find anything.

If I want to use a ' character in the string in my where statement, how do I do then ?

for example select something from some_table where some_col = 'my ' character'

Thanks for any answers.

Cheers !

/Christian Received on Fri Jan 17 2003 - 04:03:41 CST