serach for "?"

Database
N/A

serach for "?"

Hi,
I need to serach for strings with "?" (with out quotes)

example:
quest?on
mar?s
li??le

can any body throw some light on this.

-GRR
4 REPLIES

Re: serach for "?"

Hi
sel columnname from tablename where columname like '%/?' escape '/'

Probably this query will solve your problem.

Re: serach for "?"

try this.. this is right....
sel columnname from tablename where columname like '%/?%' escape '/'
N/A

Re: serach for "?"

Hi,
I am getting the following error:

Un-Named Parameter marker found.Use Import Mode

Re: serach for "?"

I've tried the following query in Queryman - it's perfectly giving the expected data.

SELECT COLUMN_NAME FROM TABLE_NAME WHERE COLUMN_NAME LIKE '%?%';

You can also try this one - same result would yield..

SELECT COLUMN_NAME FROM TABLE_NAME WHERE COLUMN_NAME LIKE '%??%' ESCAPE '?';