?
Solved

Replace non-breaking space in sql field

Posted on 2009-04-07
2
Medium Priority
?
3,697 Views
Last Modified: 2012-05-06
I have SSN's in a field that have a ascii character 160 in front of them which is a non-breaking space.  I tried teh Ltrim and replace but it seems not to have a effect how can I get ride of this space.
0
Comment
Question by:kdeutsch
2 Comments
 
LVL 12

Accepted Solution

by:
udaya kumar laligondla earned 500 total points
ID: 24087931
use  LTrim(RTrim(replace(FieldName,Char(160), ' ') ))
0
 

Author Closing Comment

by:kdeutsch
ID: 31567539
Works great thanks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question