Subject Re: Odd handling of spaces in WHERE clause?
Author rjschappe
> Trailing spaces are ignored in comparison.
> If conforms to SQL standard.
>
> If you need to take trailing spaces into accout, use LIKE:
> Select * from Address where (Company LIKE ' ')
>
> Ivan

Thaks Ivan!

Gee I don't remember that SQL standard... but alas, I am still living
in the ANSI SQL 88 mindset... and slowly trying to crawl forward...

Actually, I remember less and less these days... I guess that is what
30+ years of coding will do to you! :) ... or maybe all that
alluminum!!!

Thanks,
--Raymond