Multiple Replace In Expression

Guys ... got a puzzle kinda problem am stuck up with so asking for your help (after all .. you are the gurus)... What i need to do is append Src. to any column name that comes in the expression.


Here we go ... and the last query is part of what I was coming up with ... not exactly working :)


Create Table ColumnNames
(
ColumnName varchar(256)
)
go
Insert into ColumnNames
Select 'name'
UNION
Select 'dbid'
UNION
Select 'sid'
UNION
Select 'mode'
UNION
Select 'status'
UNION
Select 'status2'
UNION
Select 'crdate'
UNION
Select 'reserved'
UNION
Select 'category'
UNION
Select 'cmptlevel'
UNION
Select 'filename'
UNION
Select 'version'
go
Declare @Expression varchar(256)
Select @Expression = 'dbid = 1 AND cmptlevel = 100'

Select replace(@Expression,ColumnName,'Src.'+ColumnName) from ColumnNames Where charindex('Src.',replace(@Expression,ColumnName,'S rc.'+ColumnName)) <> 0