cstr() returns formatted String with thousands separator

A pure Java JDBC driver for Microsoft Access database files

Brought to you by: jamadei

cstr() returns formatted String with thousands separator

Forum: Help

Creator: logineimer

Created: 2015-04-08

Updated: 2015-04-14

logineimer - 2015-04-08

Hello again,

I got my select working. However, I ran into the next issue.

cstr(PersonNumber) formats my numbers with thousands separators like this: 29.132.512 - this is wrong because the separators don't make sense in this case.

Is it possible to avoid the format?

Greetings

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

logineimer - 2015-04-13

Anyone?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marco Amadei - 2015-04-13

Hi,
you don't need a function, but PersonNumber & ''.
Cheers Marco

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gord Thompson - 2015-04-13

UCanAccess also supports the Format() function so you could use Format(PersonNumber, '0').

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

logineimer - 2015-04-14

Thanks! But why does UCanAccess format the numbers? Is there an opportunity to simply turn off this behavior?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.