Posted onNovember 3, 2010 by Josephine searching for a column name SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name like ‘pre%’ )
