T-SQL - How to deal with SELECT If Error Logic

Question

I have a simple select statement below:

SELECT Code =   Cast([Code] as int)
FROM dbo.table

I get an error:

Conversion failed when converting the nvarchar value '?' to data type int.

I want to write IFERROR or CASE statement that would would replace error with a number such as -9999

I know it was correct. I was not sure how to deal with it. Solution works fine. Cheers — BI Dude, Nov 05 '14 at 13:50

score 5 · Accepted Answer · edited Nov 05 '14 at 13:13

5

SELECT 
    Code = CASE 
               WHEN ISNUMERIC(Code) = 1 THEN Cast([Code] as int) 
               ELSE -9999 
    END
FROM 
    dbo.table

edited Nov 05 '14 at 13:13

marc_s

answered Nov 05 '14 at 12:33

M. Page

score 0 · Answer 2 · answered Nov 05 '14 at 12:32

0

SELECT Code = Cast((case when [Code] = '?' then -9999 else [Code] end) as int)
FROM dbo.table

answered Nov 05 '14 at 12:32

juergen d

2 Answers2