RE: I need the opposite of BINARY

2003-10-20 Thread Jeff Shapiro
) or UPPER(). On Mon, 20 Oct 2003 18:05:58 +0200 (CEST), Thomas Spahni spoke thusly about RE: I need the opposite of BINARY: > Simon > > you missed this from the manual: > > > If you want to convert a number to a string explicitly, pass it as the > argument to `CONCAT()'.

RE: I need the opposite of BINARY

2003-10-20 Thread Thomas Spahni
l 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: > > ... WHERE CONCAT(anumber, aname) LIKE '12SomeString' > >

RE: I need the opposite of BINARY

2003-10-20 Thread Simon Green
] Subject: I need the opposite of BINARY Hi, I do the following: ... 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

I need the opposite of BINARY

2003-10-20 Thread Thomas Spahni
Hi, I do the following: ... 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 tra