subselect question

As in an SQL line you'd find in PHP:

select * from mytable where thiscolumn = '%whatever%'

Can I make thiscolumn = '%whatever%' be case-insensitive? I'm
pretty sure I can't, but if there's a way in SQL hints would be
appreciated. I can already do this search via a regular expression,
but that's quite slow and I'd like a better way.

--------------------------------------------------------
Christopher Wood, Community Access Technical Coordinator
Western Valley Development Authority
Nova Scotia's Smart Community
Box 251 Bridgetown, Nova Scotia  B0S 1C0
tel: (902) 665-4083/ fax: (902) 665-2878
www.wvda.com www.wvcn.ns.ca
--------------------------------------------------------