select name,isnull((select top 1 Note from t_Codes where category=name),name) as cnstr from syscolumns where id=(select id from sysobjects where xtype='U' and name='t_Projects')