select name
from some_table
where ( upper( name ) like '%HOU%' )

I am not sure what it will do to your query plan though.

-steve

On Wed, 2005-11-16 at 10:09 -0800, William Gonzáles S. wrote:

> 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
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>


[Non-text portions of this message have been removed]