Remove entire word from field

Question

Post reply

Remove entire word from field

mbrady5

SSCrazy

Points: 2835
More actions
October 28, 2009 at 5:25 pm

#385673

Hello,
I am looking to produce a query that will eliminate a whole word from a field.
Ex. Going To School
I would like to get rid of the word 'Going', as well as eliminate any spaces to the left of 'To'.
Thank you

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

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

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 1

Take a gander at the REPLACE function in Books Online... that should do the trick.

--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)

Jeffrey Williams SSC Guru Points: 90350 More actions · Answer 2

Also look up LTRIM/RTRIM in Books Online - that should take care of the leading/trailing spaces.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

raj acharya SSCrazy Points: 2805 More actions · Answer 3

hi,

this way you can do that

DECLARE @string VARCHAR(100)

SET @string = 'going to school'

SELECT ltrim(REPLACE(@string,'going',''))

Raj Acharya