Tip: Replace Spaces and New Lines with One SQL Statement

Learn an easy way to replace new lines and spaces inside a field.

by Hannes Du Preez

Aug 2, 2018

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning

~~Watch~~→

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), '')

Visit the DevX Tip Bank

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

Tip: Replace Spaces and New Lines with One SQL Statement

Learn an easy way to replace new lines and spaces inside a field.

WEBINAR:On-Demand

WEBINAR:

On-Demand