I have a below query which needs to replace the label to actual value. I can do this by using REPLACE() recursively. Is there any better way to bring the output?
I'm getting proper output from this query, however I'm curious to find better one. Thanks!
DECLARE @a AS VARCHAR(1000)
SET @A = 'This is <<FirstName>> <<LastName>> FROM <<PLACE>>, MY DOB IS ON <<DATE>> at <<TIME>>. THANKS'