SQL: case insensitive queries

[bluecrisis]

does anyone know how to write case insensitive queries. i am specifically trying to use the LIKE keyword against an oracle database.

ie: select * from tblName where fldName like '%DoG%' should return values that are not necessarily the same case ('dog' or 'dOg')

thanks

d