In article <ao3v0e$bio$2_at_reader1.panix.com>, R Chin <rchin_at_panix.com>
writes:
>which version was TRIM first available ?
>thanks
>
>
The ANSI standard trim function was first available with version 8.1.
Previous to that you used rtrim and ltrim to trim from the right and left
sides of the variable. See the SQL Manual chapter on single row functions
for more information.
HTH -- Mark D Powell --
- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
NewsOne.Net prohibits users from posting spam. If this or other posts
made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Fri Oct 11 2002 - 07:40:52 CDT
