Convert Varchar to Int
-
Hi ,
I have a case statement where i am checking for some dates and displaying a number for each date.
When the date is null i need to display #N/A.
CASE
WHEN Convert(varchar(13),column1,112) < date1 THEN 1
WHEN Convert(varchar(13),column1,112) < date2 THEN 2
WHEN Convert(varchar(13),column1,112) < date3 THEN 3
WHEN Convert(varchar(13),column1,112) IS NULL THEN '#N/A' ELSE 4
END AS Grp
The Column1 is actually a datetime.
error: Conversion failed when converting the varchar value '#N/A' to data type int.
Please suggest..
Thanks,
Nemo
-
Possible outputs are 1,2,3,4 which are parsed as INT, and 'N/A' which is a string.
Try using '1' instead of 1, '2' instead of 2, etc...
-
That works...
Thanks Ben.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply