#Lower()?
John
I the used the follwing "cute" hack for obtaining a lower(string):
BITOR(string) !!
this works by exploiting the fact that the BITOR() function defaults to
BITORing with the blank, or space caracter " ". This is hex 20 in ASCII, which
is also the distance that separates upper and lowercase characters.
However, this also means that it *only* works for alphabetic characters and
blanks, and will produce garbage for other characters (e.g. %,$,",numbers
etc.). So in the long run TRANSLATE() is much more robust.
Alex