|
|
|
Forum Member
 
Group: Forum Members
Last Login: 11/8/2009 5:14:20 AM
Posts: 38,
Visits: 74
|
|
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
Regards,
GRR
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/5/2009 6:07:39 AM
Posts: 9,
Visits: 10
|
|
Hi
sel columnname from tablename where columname like '%/?' escape '/'
Probably this query will solve your problem.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/5/2009 6:07:39 AM
Posts: 9,
Visits: 10
|
|
try this.. this is right....
sel columnname from tablename where columname like '%/?%' escape '/'
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/8/2009 5:14:20 AM
Posts: 38,
Visits: 74
|
|
Hi,
I am getting the following error:
Un-Named Parameter marker found.Use Import Mode
Regards,
GRR
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/30/2009 6:28:19 AM
Posts: 34,
Visits: 117
|
|
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 '?';
|
|
|
|