ignoring letter case in search

[wxdqz]

in doing something like:

select * from table where text like '%word%';

how could i make it so it isn't case sensitive? (so searching for "word" would find "word" or "Word" etc.)

Thanks,
Chief
<!-- m --><a class="postlink" href="http://www.crudpot.net">http://www.crudpot.net</a><!-- m -->