how to clean unwanted data in a column in sql server 2008

Question

I have a column name Newspath varchar(max). The data in the column is like this

Newspath
423.jpg64265
789.jpg41546
546.jpg7894

I want to remove all the words after .jpg word like this

Newspath
423.jpg
789.jpg
546.jpg

Please help

Answer 1

I am assuming you need to update all the rows of your table. You can update all the rows of your table like

BEGIN TRAN
UPDATE  yourtable 
SET newpath = SUBSTR(newpath,0,CHARINDEX('jpg',newpath)+2)

You can look at more for Substring and Charindex.