$

[Craig]

Can anyone tell me the difference between:

Left and Left$
Right and Right$
Mid and Mid$

???

thanks

 

[Cheryl Fischer]

Essentially no difference. AFAIK, the function calls with the $ are
included for backward compatibility.

 

[Dirk Goldgar]

Essentially no difference. AFAIK, the function calls with the $ are
included for backward compatibility.

Actually, there is a difference. The "$" versions take String arguments
(for the first argument), whereas the "non-$" versions take
Variant(String) arguments, and thus can cope with Nulls without raising
an error. This means that

?Left(Null,2)
Null

but

?Left$(Null,2)

raises Run-time error '94': Invalid use of Null.

 

[TC]

Already answered elsewhere.

PLEASE DON'T MULTI-POST. That is where you post the same question
seperately, to several newsgroups. Instead, CROSS-post. That is where you
send the message >once<, to several newsgroups, by including all their names
in the Newsgroups line, seperated by commas (or whatever).

With multi-posting, no-one can see the answers you got, in other groups to
which you posted. So, someone will waste their time by answering a question
that has already been answered in one of those other groups. With
cross-posting, readers of >each< newsgroup can see >all< the answers that
you got, in >all< the groups to which you posted.

TC