sql query help

struct · 10-26-2010, 11:50 PM

I have to search for a string with question marks and the query doesn't show any results. I'm 100% positive there are strings with ? in the front of the it but can't find any.

select * from table like '?%'

doesn't seem to work.

do I need to escape the question mark? If so, how do I escape it within the query?

paulsm4 · 10-26-2010, 11:58 PM

Hi -

Use the SQL "escape" clause:

http://www.orafaq.com/faq/how_does_o...ng_sql_queries

Code:

select * from table like '\?\%' ESCAPE '\';

struct · 10-27-2010, 12:29 AM

thank you so much.