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

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip: Escape Characters with the "@" Symbol in C#

Escape Characters with the "@" Symbol in C#

Tip: Compare Only Alphabetic Values

Compare Only Alphabetic Values

Tip: Avoid Poor Use of Reflection

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

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