Advertiser Disclosure

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

Python Wonderwords Library: Random Words and Sentences

How to Split Strings in Java

Python Logical Operators

How to Use the StringJoiner Class in Java

How to Find the Status of Threads 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

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

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