LIKE with spaces
I'm using a query ... WHERE streetname LIKE 'ST DAV%' but, of course it
doesn't work. LIKE 'ST%' does work however, so I assume the space is
causing some grief to the query parser. Ver 6.5.2 on RH linux. Can
anyone tell why this doesn't work, and more importantly, if there is a
way to make it work?
*sigh*
jb
On Mon, 10 Apr 2000, JB wrote:
I'm using a query ... WHERE streetname LIKE 'ST DAV%' but, of course it
doesn't work.
Define "doesn't work".
LIKE 'ST%' does work however, so I assume the space is
causing some grief to the query parser.
Not here. I'm using 7.0 beta. Not sure if there were changes in these
things, maybe you could dig around in the release notes.
--
Peter Eisentraut Sernanders v�g 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden