VBScript CSng() Type Mismatch

Code:

---

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?

Code:

---

Dim sngFoo
    sngFoo = Null

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

---

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

Code:

---

sngFoo = CSng(cInt(someVar))

---

but I doubt that'll even work...

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..