BEGIN

select @FinalString =(SELECT RTRIM(+ISNULL('Name','')+' : ' +ISNULL(+CAST(Name AS VARCHAR(100))+' ',''))

FROM ETCOL WHERE RIGHT_TEXT ='Name') +CHAR(10)

END

ELSE

BEGIN

select @FinalString=(SELECT RTRIM(+ISNULL('Name','')+' : ' +ISNULL(+CAST(Name AS VARCHAR(100))+' ','') +ISNULL(' DOB :'+CAST(DOB AS VARCHAR(100))+' ',''))

FROM ETCOL WHERE RIGHT_TEXT ='Name') +CHAR(10)

END

----------

If the DOB is not null, then i want the date format like : Sep 30, 2012