Hello, I have several queries with ‘LIKE’, but the
results are not good for me, for example:

SELECT NAME FROM SOME_TABLE WHERE (NAME LIKE '%hou%')

It gives me records with: “house”, “penthouse”
but records: “House”, “HOUSE”, “PENTHOUSE” are
ignored; I need a non case sensitive ‘LIKE’, how can I
solve this?

Thanks in advance,
William GS


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com