Re: Slightly OT: hex character specification in a view

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

Slightly OT: hex character specification in a view

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.