Buck wrote:
In other flavors of SQL the SUBSTR function would do the same thing

AFAIK that 'flavor' is proprietary to Oracle. The ANSI standard
equivalent is SUBSTRING.

Jamie.

--