LIKE -> Non Casesensitive Query

Hi!

What is the best way to do the following select without worrying about case:

String d='g';
select name from org where name like " + d + "%"

so if the table has:

ganc
Good Stuff
ganger

it should return everything!!

thanks Received on Tue Apr 24 2001 - 10:28:59 CDT