Please can you help - I am struggling with such a basic thing and my brain doesnt want to work. I need to prefix a piece of data from one of my quiries:
I need the "orderID" to have the words ref bfore the data:
001 would be ref001
002 would be ref002 and so on...
SELECT dbo.Opportunity.ContactEmail AS [email address], dbo.Opportunity.ContactFullName AS [customer name], dbo.Lead.LeadReference AS [order ID]
FROM dbo.Lead INNER JOIN
dbo.Opportunity ON dbo.Lead.RecId = dbo.Opportunity.ParentLink_RecID
WHERE (NOT (dbo.Opportunity.ContactEmail IS NULL))
Everything I try doesnt work I am struggling to use the correct words on google.