SELECT COL1,COL6, COL8
where col8 = cast('130' as int)
if I run this on Query Analyser I get this error:
"Server: Msg 248, Level 16, State 1, Line 1
The conversion of the nvarchar value ' 6787681034' overflowed an int column. Maximum integer value exceeded."
COL1, COL6, COL8 are all nvarchar(100) datatype on SQL Server 2000.
I I remove the cast on '130' it retuns zero data matches, am sure tere are many 130 records on te table.