Replace with len

Last Post 15 May 2008 10:41 AM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

15 May 2008 10:41 AM
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?

update cms_medorderimport
set expsig = Replace(expsig, '&', '&')

Acceptable Use Policy