CONCAT turns every this in to a string then puts them together? LIKE is not case sensitive with string? When is this turned in to BINARY?
What have I missed please Simon -----Original Message----- From: Thomas Spahni [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 15:38 To: [EMAIL PROTECTED] Subject: I need the opposite of BINARY Hi, I do the following: <somequery> ... WHERE CONCAT(anumber, aname) LIKE '12SomeString' As explained in the manual this is treated as a BINARY comparison i.e. case of the letters matter. I need a case independent comparison here. Is there a way to get the usual behaviour of LIKE in this case? (besides translating all characters to LOWER which is IMHO no elegant solution). TIA Thomas Spahni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]