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 creating udfs and that way to use regexp. Albeit, I'm not sure which approach is better from performance side: t-sql or regex. Ref: http://msdn.microsoft.com/en-us/magazine/cc163473.aspx Good luck, Marko Simic >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. Tried several >combinations for the hex pair 0D0A with no luck. Anyone done this before? > >Thanks! > >--Ben > >-- >Ben Conner b...@webworldinc.com >Web World, Inc. 888-206-6486 >PO Box 1122 480-704-2000 >Queen Creek, AZ 85242 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
