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 [email protected] 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:330707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
