Viewing 2 posts - 1 through 3 (of 3 total)
After some digging - this seemed to finally do the trick.
left (replace(replace(convert (char(255), cm.csm_description), char(13), ' '), char(10), ' '), 255) AS 'buildingpermitdescription'
I realized that the field was a text...
January 22, 2010 at 4:41 pm
#1107641
Ahhh - good to know for future reference. Thanks so much for the assistance!
January 20, 2010 at 9:39 am
#1106144