Simon you missed this from the manual:
<quote> If you want to convert a number to a string explicitly, pass it as the argument to `CONCAT()'. If a string function is given a binary string as an argument, the resulting string is also a binary string. A number converted to a string is treated as a binary string. This only affects comparisons. Normally, if any expression in a string comparison is case-sensitive, the comparison is performed in case-sensitive fashion. <unquote> It is well documented. My question was about how I could change this, because I want to perform a comparison in a NON-case-sensitive fashion. Thomas Spahni On Mon, 20 Oct 2003, Simon Green wrote: > 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]