|
|
How to remove carriage return from a record SQL
Last post 03-03-2009, 6:19 PM by twaligora. 0 replies.
-
 03-03-2009, 6:19 PM |
-
twaligora
-
-
-
Joined on 01-11-2007
-
-
Posts 57
-
-
|
How to remove carriage return from a record SQL
it appears that char (10) holds the value of a carriage return so
select
replace(ISNULL(MyValue,''),char(10),' ')
from
MyTable
|
|
|
|
|