search column name 1

[peac3]

Hi guys,

I have a table which contains few hundreds of columns and am trying to find the column name like '%amount%'
Is there any easy way to do this? other than manual search.

Thanks guys,

 

[bborissov]

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE Table_Name = 'TheTableName' AND
      Column_Name LIKE '%amount%'

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.