> I seem to recall there's a string comparison operator that does not
> ignore trailing spaces, but I can't remember what it's called. Can
> someone remind me? Or perhaps I'm mistaken?
>
> I do know that "like" respects trailing spaces.

Right. It's the LIKE operator you should use. ;-)



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/