Text function names ending in "$"

  • Thread starter Thread starter peschrader
  • Start date Start date
P

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
 
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)
 
gyygygyghgygyjgyygygygyjyiyg
Douglas J. Steele said:
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)
Click to expand...
 
Back
Top