dcsimg
 

Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Thursday Aug 2nd 2018 by Hannes du Preez

Language: SQL, Expertise: Intermediate - Learn an easy way to replace new lines and spaces inside a field.

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), '')
Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved