Advertiser Disclosure

Google+

Download our iPhone app

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

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

Tip: Building Javadocs from the Command Line

Using Optional in Java

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

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

0 Comments (click to add your comment)

Comment and Contribute

Terms of Service | Licensing & Reprints | About Us | Privacy Policy | Contact Us | Advertise

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