ScanIAm wrote:Sadly, I had to look up the syntax for replace and I'm assuming that you mean using the print function when you refer to messages? Or are you talking about raiseerror.
Hint: Requires Left, Right, LEN, and PatIndex You could also write it with Substring if you enjoy pain or are more comfi.
I would accept Print or Select. Really knowing the differences is trivial. Seeing whether you can think through the problem is more interesting.
'You' being sample candidate.