Thread: 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