declare @v_date datetime

select @v_date = (select Date_Released from dbo.Tbl_Workstream where Loan_Number = 'XXX')

SELECT v = CASE WHEN @v_date = '1900-01-01 00:00:00.000'

                              THEN ''

                              ELSE CONVERT(CHAR(23), @v_date, 21)

END FROM @v_date;

declare @v_date char(23);
select @v_date = CONVERT(char(23),
          (select Date_Released from dbo.Tbl_Workstream where Loan_Number = 'XXX'), 21);
select case when @v_date = '1900-01-01 00:00:00.000' THEN '' ELSE @v_Date END as V;