asked on SQL Conversion failed when converting the nvarchar value '3.00' to data type int.
Getting error: Conversion failed when converting the nvarchar value '3.00' to data type int.
on Field LeadTime. I've tried Cast and Convet and both fail.
on Field LeadTime. I've tried Cast and Convet and both fail.
SELECT MPN, InternalPN, CONVERT(INT, LeadTimeMin) FROM AustinFullExportTemp WHERE MPN = 'xxxxx'
Microsoft SQL ServerSQL
Last Comment
irudyk
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks!!!
Also, just in case the value in the field is not always numeric text you could use
SELECT MPN, InternalPN, CASE WHEN ISNUMERIC(LeadTimeMin) = 1 THEN CONVERT(INT,CAST(LeadTimeMin AS NUMERIC(10,2))) ELSE 0 END FROM AustinFullExportTemp WHERE MPN = 'xxxxx'