Remove Character from specific Column

Question

Post reply

Remove Character from specific Column

ahfb

SSC Enthusiast

Points: 165
More actions
November 18, 2014 at 4:37 am

#312709

Hi Firends
How to remove Character From Column,Just Character.
I want to work with number.
Tnx For Help

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

Example please.

See the first article linked in my signature line for posting guidelines.

-- Gianluca Sartori

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

To remove one character, use the REPLACE function. I suspect there's slightly more to it than that, so like Gianluca said, please post an example. It's best if you include consumable DDL, data and expected output.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Jeff Moden SSC Guru Points: 1004439 More actions · Answer 3

ahfb (11/18/2014)
Hi Firends
How to remove Character From Column,Just Character.
I want to work with number.
Tnx For Help

Do you mean you want to remove all non-numeric-digits from the column? And, like the others have stated, an example of the data you're working with would be nice.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Jeff Moden (11/18/2014)
ahfb (11/18/2014)
Hi Firends
How to remove Character From Column,Just Character.
I want to work with number.
Tnx For Help
Do you mean you want to remove all non-numeric-digits from the column? And, like the others have stated, an example of the data you're working with would be nice.

If that's what you're after, there was a good discussion at http://www.sqlservercentral.com/Forums/Topic1585850-391-1.aspx.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions