Text function names ending in "$"

[peschrader]

Hi !

I'm using Microsoft Access 2003 and Windows Vista.

For table design there is a validation rule expression builder.
It offers text functions ending in a "$".
E.g., there is a function TRIM$ in addition to TRIM.
What's the meaning of the $ character?

Thank you very much for your kind help.

Peter

 

[Douglas J. Steele]

It means that the function returns a string, not a variant, so will be
slightly faster (not that you'd likely notice the difference). It also means
that it will raise an error if the value passed to it is Null, though, so
you need to know your data before using it (or else force the argument to be
a string by concatenating a zero-length string to it)

 

[kyle hicks#]

gyygygyghgygyjgyygygygyjyiyg

It means that the function returns a string, not a variant, so will be
slightly faster (not that you'd likely notice the difference). It also
means that it will raise an error if the value passed to it is Null,
though, so you need to know your data before using it (or else force the
argument to be a string by concatenating a zero-length string to it)