I'm trying to copy a request from one table to another Table and concatenate a standard text to certain fields just for easy identification on the front end. Concatenation is fine but year over year I'm concatenating the same text over and over again
How do I make sure that I only concatenate the standard text if it is not already part of a field.Below is my query
INSERT INTO [CustomerInfo].[dbo].[RequestDataDraft]
,[title] + ' ' +'Renewal Request'
where reqno = @oldreqno
the Renewal Request is the standard text I concatenate and it is getting duplicated. How do I only concatenate if it does not exist first hand