Tee Time (11/16/2012)
something like this may work for your purpose, but I think that may depend onSELECT REPLACE(REPLACE(yourfield, CHAR(13), ''), CHAR(10), '')
This basically replaces the char with nothing.
Raymond van Laake (11/16/2012)
It would work indeed, but I'm hoping to find a better wayThx!
Define "better" because if those are the only two characters you really need to worry about, then you just blew off the absolute best way. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.