Re: SQL Select statement help needed

Hi

have you tried converting both the field and the value to upper (or lowercase). I can quite remember what the function is but it looks like this:

select * from YourTable where UCASE(fieldname)=UCASE(value)

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful