maybe using something like

case when dbo.Phone.Phon_Number like '0%' then substring (2,##) else dbo.Phone.Phon_Number end

try this

create table #temp_promp(

PA_EnterpriceID int

, PP_Name varchar(100), PP_ID int

)

insert into #temp_promp

values (9,'1st Quarter 2010 Remove from PIP Agency Pruning',132)

insert into #temp_promp

values (9, '3rd Quarter 2009 PIP Agency Pruning', 112)

insert into...

is there any records in that dual table?