[mmtw816]

Hello,

is there a way to search for a ' ? I tried things like :
Select ... from ... where ... like '%\'';
But this doesn't work. Does anyone knows for a way to solve my problem?

Thanks a lot.

[ladwig]

Hi,
try this
select field from table where field matches "se?rch"
or
select field from table where field matches "se*ch"

[mmtw816]

Maybe my question was not clear enough. In a table with values :

id value
----------
01 appel
02 rose
03 ch'eese
04 ru'st
05 rice

I would like to find ch'eese and ru'st because they contain the single quote ('). The same problem applies to my search for - in a field.

I still hope someone can help me or simply tell me that this in totally not possible.

[ladwig]

Hi,
what about
select * from table where field matches "*'*"

[mmtw816]

I gave it a trie but matches is not known. So I tried again with
select * from table where field like "*'*";
But this also does not work.
Any idea?

[ladwig]

Hi,
what kind of sql environment do you use? This works for example under informix dbaccess or informix sql editor.

[ladwig]

Hi,
i tried under dbaccess:

select * from table where field like "%'%"

[mmtw816]

Hello Juergen Ladwig,

I also tried under dbaccess:

select * from table where field like "%'%"
select * from table where field like "%-%"

and everything works just fine. Thanks a lot for your help !