Need SQL Help

[dmaier]

I need help with an update SQL. Basically if there is a phrase at the end of a column that I want to remove.

Example:
Hawks' co-Owner stays optimistic-September 1
Keeping Camby a taxing issue-September 1
Nuggets strive to aim higher-September 1

There are a number of these and what I would like to do is mass delete the -September 1 from the field. Is there a way to do this through SQL on an Microsoft SQL Server?

 

[gmmastros]

Make sure you have a good backup first.

Update TableName
Set    Column = Left(Column, Len(Column)-12)
Where  Column Like '%-September 1'

-George

"the screen with the little boxes in the window." - Moron