Difference between left() and left$() 1

[Spike1950]

I know how to use functions, but I can't seem to find any explanation on when to use the built-in functions that come with a dollar sign. Not even in the Access Bilble. When do I use a function like Left() without $, and when should I use Left$() with the sign?

Any clear information on this would be very much appreciated.

 

[Ed2020]

Left() returns a variant. Left$() returns a string. The vast majority of the time it doesn't make any difference. If you know you want to return a string use Left$().

There are lots of other functions that have the same dual personalities. Have a look in the expression builder for more examples.

Hope this helps.

Ed Metcalfe.

Please do not feed the trolls.....