Subject | Re: Odd handling of spaces in WHERE clause? |
---|---|
Author | rjschappe |
Post date | 2004-06-20T18:06:18Z |
> Trailing spaces are ignored in comparison.Thaks Ivan!
> If conforms to SQL standard.
>
> If you need to take trailing spaces into accout, use LIKE:
> Select * from Address where (Company LIKE ' ')
>
> 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