Re: Ignoring spaces in a comparison

If the spaces are embedded within the string there is no way to do what
you want except to write a UDF that performs the comparison.

-- 

"Russell" <russell@removethis.smxi.com> wrote in message 
news:47e102ef@newsgroups.borland.com...
> is there a simple way of ignoring spaces in a select, sort of
>
> WHERE IgnoreSpaces("MYFIELD") = 'MYVALUE'
>
> or is there a simple LIKE pattern that will achieve this effect? Not 
> really worried about performance on this one.


If the spaces are strictly leading and/or trailing, then you will find the 
value with:

    WHERE "MYFIELD" LIKE '%MYVALUE%'

-- 
Wayne Niddery - TeamB (www.teamb.com)
Winwright, Inc. (www.winwright.ca) 

is there a simple way of ignoring spaces in a select, sort of

WHERE IgnoreSpaces("MYFIELD") = 'MYVALUE'

or is there a simple LIKE pattern that will achieve this effect? Not really 
worried about performance on this one.

many thanks 

Thanks, both of you. It is pretty musch as I expected, but hoped wasn't the 
case.

The alternative was to create a pretty heavy pattern from the value, but 
guess I will put the effort into updating the database and program to add 
some additional fields (actually a separate table) for creating the indexing 
strings.

"Bill Todd [TeamB]" <no@no.com> wrote in message 
news:47e13786@newsgroups.borland.com...
> If the spaces are embedded within the string there is no way to do what
> you want except to write a UDF that performs the comparison.
>
> -- 
> Bill Todd (TeamB)