I have a 3rd party system I have to receive and then feed into another 3rd party db. The 2nd db will not accept ampersands by themselves, they need to be replaced with &. Problem is these is a free form text field which is limited to 200 characters. So the replace can choke if the original message was 200 characters. What would be the best way to add to this left?
set expsig = Replace(expsig, '&', '&')