Convert string 2

[tseh]

How do I convert a string to a number?

 

[Veep]

From vbscript documentation:

CInt(expression)
Returns an expression that has been converted to a Variant of subtype Integer.

CLng(expression)
Returns an expression that has been converted to a Variant of subtype Long.

CSng(expression)
Returns an expression that has been converted to a Variant of subtype Single.

CDbl(expression)
Returns an expression that has been converted to a Variant of subtype Double.

There's more but this should get you going.

 

[Bullschmidt]

So for a quick example:

MyVariable = CLng(MyVariable)

But you should experiment with things like this to be sure that it doesn't cause an error with unexpected input so IsNull() and IsNumeric() are good functions to know too.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer

http://www.Bullschmidt.com

ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...

 

[tseh]

Thanks. Works like a charm!