if exists (select * from sysobjects where id = object_id('dbo.sp_findcol') and sysstat & 0xf = 4)
	drop procedure dbo.sp_findcol
GO

create proc sp_findcol
@colname varchar(30) = '%'
as

select 'Search value = '+ @colname
print ' '
select 
'source_table'=convert(char(20),object_name(s.id)),
'column_name'=convert(char(20),s.name),
'datatype'=convert(char(12),t.name), 
s.length
from syscolumns s, systypes t,sysobjects o
where 
s.usertype *= t.usertype
and
s.id = o.id
and
o.type = 'U'
and
s.name like '%' + @colname +'%'
GO