Hi,
CF:
my_string = REReplace(my_string,"[\r\n]","","all")
T-SQL:
set my_string = REPLACE ( my_string , CHAR(13) , '' ) -- Carriage return
set my_string = REPLACE ( my_string , CHAR(10) , '' ) -- line feed
In case you found it is best to do on db side, in mssql 2005+ you can utilize
.net for c
Hi,
I have a situation where I need to create a view in a SQL Server
database. One of the character fields has embedded cr/lf pairs, which I
need to get rid of. The REPLACE function will do that, but how do I
specify the cr/lf combination?
Putting it in as characters throws off the view.
2 matches
Mail list logo