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 wrote:

> 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!!

The ones without a $ return a variant.  The ones with a $ return a string.

Excellent , thanks mate!!

Cheers,

"Rick Brandt" wrote:

> DontKnow wrote:
> 
> > 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!!
> 
> 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

DontKnow wrote:
> Excellent , thanks mate!!
> 
> Cheers,
> 
> "Rick Brandt" wrote:
> 
>> DontKnow wrote:
>>
>>> 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!!
>> The ones without a $ return a variant.  The ones with a $ return a string.
>>
>> .
>>