Sql Like statement to ignore case 2

[colin81]

Hi all

Is there a way to use a like statement within a where clause to ignore case. As at present when I query a db it only finds the records if the case is matched also.

I.e

SELECT * FROM tbl WHERE myfield LIKE '%SMITH%'

Will only pull back SMITH when I want it to find smith SmiTH etc as long as it reads smith.


Many Thanks
Colin

 

[PHV]

Depending your DBMS you may use a function like uppercase or toupper or ucase or ....

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dreameR25]

I am guessing that the the poster is an Oracle User in which case you could try and use UPPER(), LOWER() or INITCAP() functions to achieve your result.

Something like this might help :

SELECT * FROM tbl WHERE UPPER(myfield) LIKE '%SMITH%'

 

[colin81]

Thank you both for your very quick replies, I am indeed using oracle and using the UPPER() function worked immediately.