View Single Post
Old June 23rd, 2003, 07:31 PM
Jeff Mason Jeff Mason is offline
Friend of Wrox
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post

Just a small correction; SQL Server does not have a TRIM function. It does, however, have LTRIM and RTRIM, which respectively trim spaces from the left and right hand side of a character string. Nest these one inside the other to simulate the (VB) TRIM function.

Jeff Mason
Custom Apps, Inc.