Why use a dollar sign in Mid function

rakuen · Oct 25th 2010

Hi

I'm using the mid function to return a character.

I was wondering what is the difference in Mid and Mid$ ?

I saw somebody using the dollar sign, and i can't find the reason for this.
For example

Code

Mid$(baseString, Int(Rnd() * Len(baseString) + 1), 1)

Rob Xaos · Oct 25th 2010

Re: Why use a dollar sign in Mid function

They are just aliases for the same function. I believe that Mid$ is for backwards compatibility with older code.

rakuen · Oct 26th 2010

Re: Why use a dollar sign in Mid function

Thanks

After searching information i found out that $ might also mean it returns string directly (instead of variant), which means faster code processing.

Rob Xaos · Oct 26th 2010

Re: Why use a dollar sign in Mid function

I did a little further checking and there is a slight difference according to this post:http://bytes.com/topic/access/…er-use-if-these-functions

Quote

The difference between the functions with the $ and those without is how
they handle Nulls. The ones with the $ are text only and will give you an
error if you pass them a Null.

If there is any performance difference then it will be negligible.

Why use a dollar sign in Mid function

Participate now!

Share