Difference between RTrim and RTrim$

[DataChick]

In MS Access in the Expression Builder there are number of Built In Functions listed both with and without the $.

What is the significance of the $?

What does it do differently and when should I use the one with the $ and when should I use the one without?

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents."
-Nathaniel Borenstein

 

[PHV]

The function ending with $ return a String, the other return a Variant of subtype string.
The $ version is supposed to be faster.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244