MS SQL – select CS.Ref, CS.C, DT.ID, DT.Init, DT.Surname, 'C' , 'C' , 100 , case when Convert(Varchar(10),CA.A,120) is null.
MS SQL – select CS.Ref, CS.C, DT.ID, DT.Init, DT.Surname, 'C' , 'C' , 100 , case when Convert(Varchar(10),CA.A,120) is null.
A few highly recommended friends...