terminating strings

W

wxdqz

New Member
help! i'm having problems with the select query in oracle

for example if i have:

SELECT * FROM TABLE WHERE name='ken's kids'

I get an error. but:

SELECT * FROM TABLE WHERE name='kens kids'

works. Oracle seems to think that the first string has terminated at the 'ken'. if i try using double quotes:

SELECT * FROM TABLE WHERE name="ken's kids"

I get an invalid column error. can someone help?
 
You must log in or register to reply here.
Back
Top