Ok, thanks, it sure seems like REPLACE would be the way to go.

Views don't seem possible.

This is invalid syntax because of the parameter.

CREATE VIEW myView

AS

select REPLACE(footer,'@client',@client) from Footers

I'll probably use a procedure

CREATE PROCEDURE myProc

@footerID int,

@client varchar(30)

AS

select REPLACE(footer,'@client',@client) from Footers where FooterID = @footerID

Then call it like

EXEC myProc 1,'MyNumberOneClient'

Downside here is my parameter list may grow. I may have @Country

I assume I could nest my replaces.

select REPLACE(REPLACE(footer,'@client',@client),'@Country',@Country) from Footers where FooterID = @footerID

Then I would need to ALTER my procedure as new parameters are created or I could create generic parameters sufficient to cover anticipated needs.

CREATE PROCEDURE myProc

@footerID int,

@param1 varchar(30),

@param2 varchar(30),

@param3 varchar(30),

@param4 varchar(30)

AS...

DECLARE @client varchar(30),

DECLARE @Country varchar(30)

etc

SET @client = @param1

SET @Country = @param2

--add new parameters as needed

SELECT ...--nested REPLACE for as many parameters as needed

EXEC myProc 1, 'MyNumberOneClient', NULL,NULL,NULL...

My goal here would be to not have to go back and modify the execution of the procedure as new parameters are added. I should be able to modify the procedure only.

Sorry for the aircode above and for thinking out loud...