Replace Spaces and New Lines with One SQL Statement

You can replace new lines and spaces inside a field with a statement similar to the following:

REPLACE(REPLACE(LTRIM(RTRIM(FIELD_NAME)), CHAR(13), ''), CHAR(10), '')

Hannes du Preez

Submit a Tip

Browse "Database Development" Tips

Browse All Tips

0 Comments (click to add your comment)

Comment and Contribute

Advertiser Disclosure: Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.

Thanks for your registration, follow us on our social networks to keep up-to-date

WEBINAR:On-Demand

Replace Spaces and New Lines with One SQL Statement

WEBINAR:

On-Demand