Simon Oliver wrote:
>
> Saw this on the perl-win32-database mailing list.
>
> Joe, is SQL::Statement case sensitive for LIKE operations?
Yes, LIKE is case sensitive. However the CLIKE operator is provided as
a case-insensitive LIKE.
> Looks like sets and ranges aren't available either:
> LIKE '[Ss]ilicon'
I have no plans to support that syntax. However, the next release of
SQL::Statement includes the UPPER() and LOWER() string functions and the
IN predicate so there will be at least three ways to accomplish
something similar:
WHERE foo IN('silicon','Silicon')
WHERE foo CLIKE 'SiLiCoN'
WHERE UPPER(foo) = 'SILICON'
--
Jeff
