Is it possible to execute a query using a where clause that allows case
insensitive comparison between a field and text.
For example:
select * from account where username = 'test'
where username could be 'Test', which would be a match. As is, this
compare is case sensitive.
grep'd the source, but stricmp is only used for keywords and not actual
column data.
Any help would be greatly appreciated.
Thanks,
Mark