Experts Exchange connects you with the people and services you need so you can get back to work.
Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
declare @p varchar(100)
set @p='char(13) + char(10) 689 Will Street char(13) + char(10) Columbus char(13) + char(10) GA';
Open in new window
set @p='+ char(13) + char(10) + 1 Main St. + char(13) + char(10) + Ames + char(13) + char(10) + IA '
set @p= rtrim(replace(@p,' ',' '));
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment