What is the meaning of the "$" in say the left$ function

  • Thread starter Thread starter DontKnow
  • Start date Start date
D

DontKnow

Hi Guys,

Just a quick question with regard to the dollar sign at the end of the Left,
right, mid etc type functions.. i do not know what the $ means and am unable
to find/track down what it means ??

Does anyone know when /where it should be used??
The help is unhelpful in this particular case!!

Many thnaks for your support!!

Cheers,
 
DontKnow said:
Hi Guys,

Just a quick question with regard to the dollar sign at the end of the
Left,
right, mid etc type functions.. i do not know what the $ means and am
unable to find/track down what it means ??

Does anyone know when /where it should be used??
The help is unhelpful in this particular case!!

Many thnaks for your support!!
Click to expand...

The ones without a $ return a variant. The ones with a $ return a string.
 
Also, the ones with $ require that the first argument not be null or you will
get an error. The ones without $ handle nulls.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top