Avatar of bfuchs
bfuchs
Flag for United States of America

asked on 

Add preceding wording to SQL results.

Hi Experts,
I have the following formula, and would like to precede it with some wording (for example 'Here is your list'), in case the formula returns something, how can I do it?
SELECT snv_id = STUFF((
SELECT ', ' + snv_id + ' ' + CONVERT(VARCHAR(10), Visit_Date, 101) + ' ' + Client_Last_Name + ' ' + ' ' + Client_First_name + char(10) 
FROM _v_v_VisitNotes_Browser
where _v_v_VisitNotes_Browser.nurse_User_ID_num_SNV= '[@authfield:Nurse_UserName]'
FOR XML PATH('')
), 1, 1, '')

Open in new window

Thanks
DatabasesMicrosoft SQL ServerSQL* Caspio

Avatar of undefined
Last Comment
bfuchs

8/22/2022 - Mon