also your format has to be consistent if you use PARSENAME otherways results can be unexpectedfor example if you've just abcd_1234 it wont workif you can atleast guarantee that you want part from first _ then you can do thisSELECT LEFT(STUFF(field,1,CHARINDEX('_',field),''),CHARINDEX('_',STUFF(field,1,CHARINDEX('_',field),'')+'_')-1)FROM table
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/