VBScript CSng() Type Mismatch

[CiberTHuG]

Dim sngFoo
    sngFoo = CSng(someVar)

Am I the only one who thinks that the above code should set sngFoo to 0. or Null and not return a Type Mismatch error if someVar is not numeric?

I guess I have to use this?

Dim sngFoo
    sngFoo = Null

If IsNumeric(someVar) Then sngFoo = CSng(someVar)

[punkpie_uk]

VB Script always returns a type mismatch error if it doesnt like what you are doing. You could try

sngFoo = CSng(cInt(someVar))

but I doubt that'll even work...

[CiberTHuG]

I've never noticed if CInt() would return a Type Mismatch error, too. But nesting the CInt() in the CSng() will loose precision, as n.n would become n and then n..