Difference between trim and trim$ 
Author Message
 Difference between trim and trim$

What is the difference between trim and trim$?
str and str$?
mid and mid$?
left and left$?, etc.

Thu, 15 Dec 2005 20:20:55 GMT  
 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


Thu, 15 Dec 2005 20:37:11 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Trim not trimming?

2. Trim() vs Trim$(), etc

3. Equivalent functionality to trim - but with a differenct character set trimmed

4. Trim vs Trim$

5. Trim Function

6. cross trim function and replace command

7. Right trim in table entries

8. Cant fix Trim error

9. Trim, Len, Mid Errors

10. Trim and DateAdd functions No Longer Working

11. Trim() function in query can't be run in Access Runtime Environment

12. Trim leading zeros from string


Powered by phpBB® Forum Software