declare @intObjectID int
declare @intColumnType int
declare @vrhrNameTable varchar( 255 )
declare @vrhrNameField varchar( 255 )
declare @sqlText as nvarchar( 4000 )
declare @SearchText as varchar( 100 )

set nocount on

set @vrhrNameTable='sales'
set @SearchText='%MA%'
set @sqltext='select top 1 * '+' into ##tmp from '+ @vrhrNameTable
exec sp_executesql @sqltext
set @sqltext='delete from ##tmp'
exec sp_executesql @sqltext

select @intObjectID=[id] from sysobjects where type='U' and name=@vrhrNameTable
declare crScanColumn cursor for
  select type, [name] from syscolumns where id=@intObjectID

open crScanColumn
fetch next from crScanColumn into @intColumnType, @vrhrNameField
while @@fetch_status= 0 
 begin
   if @intColumnType in ( 35 , 39 , 47 , 50 )
       set @sqlText='insert into ##tmp select * from ' +@vrhrNameTable+' where ' + @vrhrNameField + ' like '+''''+@SearchText+''''
   else
       set @sqlText='insert into ##tmp select * from ' +@vrhrNameTable+' where cast(' + @vrhrNameField + ' as varchar(50)) like '+''''+@SearchText+''''
   exec sp_executesql @sqltext
   fetch next from crScanColumn into @intColumnType, @vrhrNameField
 end
close crScanColumn
deallocate crScanColumn
set @sqltext='select * from ##tmp'
exec sp_executesql @sqltext
drop table ##tmp