Difference between trim and trim$
left can accept null as a value, and the whole expression will return a
value of null.
left$ can NOT accept a null value.
Hence, for expressions in the queries that may have null values, or if you
are using variants, then you should use the function with NO "$".
The ones with $ are there for older code, and also run faster. If your code
does not need to deal will nulls or variants, then you can use the "$" ones.
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
http://www.attcanada.net/~kallal.msn
