how case insensitive search is done.
like in table there are
"a"
"A"
then both should come when condition is ="a"

I haven't used informix. But if it is case sensitive in the matching (like Oracle is) then you need to shift everything to the correct case.

So if you want to see if everything starts with 'A' and 'a' then it's something like:

select * from <table> where upper(columnname) like 'A%'

If you're comparing against a variable, it's more or less the same:

select * from <table> where upper(columnname) = upper(varname).

Or use the MATCHES operator with the regular expression like operand:Regards,
Hans