sql server question

[Brian Percival]

I am kinda new to tsql programming and trying to find a quickie from google and such for a solution.

What I want is to get a list of tables and columns that contain a certain string. I actually want to replace all such occuranaces with some other string but here is how I started:

  
Declare @tn varchar(100)
Declare @cn varchar(100)
 
Declare mycursor cursor for
select top 3 table_name , column_name from information_schema.columns where data_type like '%varchar';
Open mycursor;
 
fetch next from mycursor into @tn,@cn;
while @@fetch_status = 0
begin
 
if exists (select @cn from @tn where @cn like '%MYSEARCHSTRING%')
print @cn + ':' + @tn ;
 
fetch next from mycursor into @tn,@cn;
 
end
close mycursor
deallocate mycursor
 
 

When I try to run ths, it complains that table variable @tn is not declared. Obviously I cann't use a varchar variable in place of a table, looks like..

Can anyone point out how I should change the above? I basically want to use the @tn and @cn as table name and column name in my 'select' inside the loop. HOW???

Thanks for your time.

[Brian Percival]

I got this from

sqlteam.com forums

Hope this helps posterity.

[Jeanne Boyarsky]

Thanks for posting the solution Brian!