Hi,

As the case statement is the usual go to, you could try the case statement as below.

sum(case when sc.numberofprocedures is null then 1 else sc.numberofprocedures end)

Hi,

Since all the dates have the wording 'Date of Hire' in front of the date, look for that.

Quick example as below.

declare @string varchar(150)

set @string = 'xxxxxxxx - Date of Hire...