• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3789
  • Last Modified:

Replace non-breaking space in sql field

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
kdeutsch
Asked:
kdeutsch
1 Solution
 
udaya kumar laligondlaTechnical LeadCommented:
use  LTrim(RTrim(replace(FieldName,Char(160), ' ') ))
0
 
kdeutschAuthor Commented:
Works great thanks
0
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

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now