I am pulling data off a table, where sometimes the data is null and sometimes it is not.
I currently use the following in a select statement, and it errors out when I have a null value.
select convert(numeric(15,1),Qualify)
from tablename
If there is a value, it works fine. If it is null, I get an error.
I need a case statement to determine when its null, and when its not use the convert use do nothing or populate the value with a blank (not sure if T-SQL uses the '').
Help is much appreciated.
I currently use the following in a select statement, and it errors out when I have a null value.
select convert(numeric(15,1),Qualify)
from tablename
If there is a value, it works fine. If it is null, I get an error.
I need a case statement to determine when its null, and when its not use the convert use do nothing or populate the value with a blank (not sure if T-SQL uses the '').
Help is much appreciated.