[thelist] SQL Server 7: CONVERT function

Scott Dexter sgd at ti3.com
Wed Mar 21 10:10:07 CST 2001


 
> So Big Question:  Why would it be that the CONVERT function 
> (which should 
> return 0 if an input is not convertable to an int if I 
> recall) work on one 
> machine and not on another?  Thoughts?  Ideas?
> 

 From the SQL Server 7 docs:

SQL Server returns an error message when char, nchar, varchar, or nvarchar
data is converted to int, float, numeric, or decimal; or when an empty
string (" ") is converted to int or float.

I'd check your data, make sure it matches up (despite the DTS wizard)

sgd




More information about the thelist mailing list