declare @txt varchar(20)
set @txt = 'a'
SELECT     O.name + '.' + C.name AS Nombre, C.column_id AS NumeroColumna, sys.types.name as TipoDeDato, sys.types.max_length TamanoMaximo, sys.types.precision as Precision, sys.types.scale as Escala, 
                      sys.types.is_nullable as Nullable, sys.types.is_user_defined as DefinidoPorUsuario
FROM         sys.columns AS C INNER JOIN
                      sys.objects AS O ON C.object_id = O.object_id INNER JOIN
                      sys.types ON C.user_type_id = sys.types.user_type_id AND C.system_type_id = sys.types.system_type_id
WHERE     (C.name LIKE N'%' + @txt + '%')
ORDER BY O.name, NumeroColumna