if you've no other occurance of numbers then you can use below logic irrespective of length of whole stringINSERT INTO NewTableSELECT LEFT(STUFF(field,1,CHARINDEX('%[0-9]%',field)-1,''),CASE WHEN CHARINDEX('%[^0-9]%',field)>0 THEN CHARINDEX('%[^0-9]%',field)-1 ELSE LEN(field) END)FROM table
do the SELECT .. INTO only if NewTable doesnt exist already------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs