Thnx Steve n GilaMonster.....
What i have done is i have created below SP;
declare @WhereCond varchar(max)
declare @BeforeWhere varchar(max)
declare @AfterWher varchar(max)
declare @totalquery nvarchar(max)
set @BeforeWhere=
'select * from Mytable where'
select @WhereCond=CNFGRTN_VAL from...