mid$ vs mid

  • Thread starter Thread starter JeffL
  • Start date Start date
JeffL said:
What is the difference between the text functions that do and don't end in
$?
Click to expand...


The string-handling functions whose names end in '$' are string-only
functions -- they can't handle Null values. The non-'$' versions of them
take Variant arguments, and so can deal with argument values that are Null.
 
thanks

Dirk Goldgar said:
The string-handling functions whose names end in '$' are string-only
functions -- they can't handle Null values. The non-'$' versions of them
take Variant arguments, and so can deal with argument values that are Null.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Chris O'C via AccessMonster.com said:
And string-only functions (mid$, left$, right$, etc) run a wee bit faster
too.
Click to expand...


Agreed. While the difference may be tiny, I try to use them whenever I know
I'm only dealing with strings. Sometimes I forget, but certainly in any
function where I expect performance to be critical, such as one called in a
query.
 
Back
Top