title: How can specific columns be excluded from results when selecting from INFORMATION_SCHEMA?
body: <p>Here is my previous question on how to iterate a string in SQL Server:</p>
  
  <p>Now how can I specifically select column names?
  here is my code for selecting columns:</p>
  
  <pre><code>SELECT 'Field '+CAST(ROW_NUMBER() OVER (ORDER BY ordinal_position) AS varchar(5))+': ' + 
  COLUMN_NAME
  FROM information_schema.columns 
  WHERE table_Name = 'SystemDefined' and table_schema = 'schemaAsset'
  </code></pre>
  
  <p>Here is the output:</p>
  
  <pre><code>Field 1: Asset_No
  Field 2: AssetCategory
  Field 3: AssetClassification
  Field 4: PurchaseType
  Field 5: Department
  Field 6: RespPerson
  Field 7: Status
  Field 8: Location
  </code></pre>
  
  <p>This the output I want when selecting specific column names:</p>
  
  <pre><code>Field 1: Asset_No
  Field 2: AssetCategory
  Field 3: AssetClassification
  Field 4: PurchaseType
  Field 5: Department
  Field 6: RespPerson
  Field 7: Status
  </code></pre>