using IF in a SQL Server View

Question

Hello,

I have a view in SQL server that translates from one schema version to another.
Currently, the view looks like this:

SELECT newValue AS oldValue  
FROM dbo.MyTable

The trouble is that, in the new schema, newValue is not nullable, so we set it to -1 to denote empty fields, but in the old schema, it was nullable.

How can I do something to the effect of:

SELECT  
(  
  IF( newValue > -1 )  
    newValue as oldValue  
  ELSE  
    NULL as oldValue
)  
FROM dbo.MyTable

Answer 1

SELECT  
  case when newValue > -1 then  
    newValue  
  else  
    NULL
  end as oldValue
FROM dbo.MyTable