first you need to determine if data coming in Decsription column has consistent format.Once thats fixed, you can apply a logic based on CHARINDEX and SUBSTRING functions to get the desired part out of the stringsomething likeUPDATE tableSET Title =LEFT(STUFF(Description,1,CHARINDEX('-',Description),''),CHARINDEX('-',Description)-1)WHERE LEN(Description) - LEN(REPLACE(Description,'-',''))>1
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs