round command

[elly00]

hi

we are using vbs reading from a sql table
As yo know the decimal separator for sql server is "."

Now trying to run a round command it doesn't work because it's waiting for "," as separator..is that possible?

So If I run round(76.25) it doesn't work
If I run round (76,25) it works correctly..

 

[strongm]

What language have you got set on your PC?

 

[elly00]

italian settings

 

[strongm]

Ok - so you are retrieving the data as text rather than as a number ... so you could try

round(replace("76.25", ".",",")) ' Convert to European decimal separator

 

[strongm]

Hello?