Re: Adding an exact equality operator to SQL based product

From article <1992Oct15.195210.26532_at_smartstar.com>, by frank_at_smartstar.com (Frank Dziuba):
>
> We have a 4gl product which is closely tied to SQL. Because of this,
> the 4gl string comparison operator ("=") ignores trailing blanks when comparing
> 2 strings.

The exact operation of the "=" operator in the case of trailing blanks varies between implimentations, so assuming that "=" will ignore trailing spaces is risky. Sybase will ignore trailing space, Gupta and Oracle will not.

--
__________________________________________________________________________
troy_at_cbme.unsw.EDU.AU	Overworked, overcommited and always multitasking.