Posted on 2010-11-21
I am using SQL 2008 R2
Data inside the table itself is in this format. DataType is Float but I want to convert it nvarchar.
Below numbers are scan numbers, I need to get first 14 digits. I am not sure why its not converting.
and while query executing I am getting this error
Arithmetic overflow error converting expression to data type nvarchar.
SELECT convert (nvarchar (14), CONVERT (BIGINT,[SCAN_NUMBER])) as SCAN_NUMBER
where [SCAN_NUMBER] > 9999999999999
Thanks for the help