stefy (@@@ò.@@@@@@@.it) writes:
I'd like insert null value from a query but i can do it,
if my query is :
UPDATE table:name UPDATE euro='' WHERE id='5';
i have a sybase message warning like this :
Error converting data type varchar to numeric.
Why ????
I would guess that id is a numeric column, whence the error. I don't know
about Sybase these days, but up till SQL 6.5, MS SQL Server did not have
auto-conversion from numeric to string and vice versa. If Sybase still
does not have this auto-conversion, that's 1-0 to Sybase.
And as David Portas pointed out, use NULL if you mean NULL. The
empty string is something else. (And is likely to be expanded to a
single space on Sybase.)
--
Erland Sommarskog, SQL Server MVP,
so****@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp