select case when 'abc' LIKE 'ABC' then 2 end<BR><BR>But I would benefit from some further info<BR><BR><BR>Dutch:<BR><BR>SELECT 'abc' LIKE 'ABC' <BR><BR>will return 1 as the expression 'abc' like 'ABC' is true and true is translated to 1 in mysql.
ANSI SQL 99 has support for boolean expressions, so a query such as <BR><BR>Select 'abc' like 'ABC' from t<BR><BR>is valid. It would return either the boolean constant true or the boolean constant false, so returning 0/1 in this context is a Mysql invention. Whether the expression 'abc' like 'ABC' is true or not depends on which collation the default character set is associated with. The choice of default character set and collation is implementationed defined in the standard specification. It seems that most DBMS has a case insensitive collaton as default.<BR><BR><BR>Note that that you must have a from clause in a select statement in ANSI SQL. It is possible to get a result set without having a reference to a table using the statement<BR><BR>values ('abc' LIKE 'ABC')<BR><BR>As far as I know, no system, except maybe ocelot, supports this syntax.