TODAY'S HEADLINES | ARTICLE ARCHIVE | FORUMS | TIP BANK

Specialized Dev Zones

Research Center

eBook Library

.NET

Java

C++

Web Dev

Architecture

Database

Security

Open Source

Enterprise

Mobile

Special Reports

10-Minute Solutions

DevXtra Blogs

Slideshow

Capitalize the First Letter of Every Word with CSS

Tip: Capitalize the First Letter of Every Word with CSS

Tip: Employ This SQL Stored Procedure to Rename a Column

Employ This SQL Stored Procedure to Rename a Column

Building Javadocs from the Command Line

Home » Tip Bank » Database Development

Comment on this Article

Language: SQL
Expertise: Intermediate

Aug 2, 2018

WEBINAR:

On-Demand

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

~~Watch~~→

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

Sitemap

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