var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: case insensitive search
how case insensitive search is done.
like in table there are
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.
Originally Posted by lodha13
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:
WHERE column MATCHES '[Ss][Tr][Ii][Nn][Gg]'