Searching with LIKE '%_%'

[nada1234]

I would like to search a field for the underscore character (ansi 95). The problem is that SQL thinks of the underscore character ( _ ) as a single character wildcard. If I say LIKE '%_%'it is the same as LIKE '%'. How can i search for an underscore?

 

[dickiebird]

You use the escape phrase

....like "%*_%" escape *

The asterisk (it could be any character in reality)
escapes the wildcard character - (underscore)

....like "%X_%" escape X

is just as valid

HTH
;-) Dickie Bird
db@dickiebird.freeserve.co.uk

 

[angiole]

You might try the following if your platform is Oracle

SELECT COLUMN1
       ,INSTR(COLUMN1,'_')  
FROM   ALL_TABLES 
WHERE  INSTR(TABLE_NAME,'_') > 0

Cheers
AA 8~)

 

[angiole]

Should have provided more of an explanation. INSTR is the Oracle position function. Other DBMS have similar. The query simply asks that the position of '_' is not zero, meaning not found.

Cheers again AA 8~)