Monday, July 2, 2007

Annoying Issue with Float and IsNumeric

Warning:  When you use IsNumeric in VBScript, it will allow commas to pass.  If you don't remove those commas from the string and pass it to a T-SQL procedure which expects a Float, you will get an error "

Error converting data type varchar to float."

 

No comments: