title: Are functions allowed in SQL Server's Import/Export Wizard?
body: <p>I am using SQL Server Import and Export Wizard to transfer data from an Excel file into a table. I wrote the following query in the wizard's query option:</p>
  
  <pre><code>Select
      ISNULL([Col 1], [Col 2]),
      [Col 3]
  FROM [myExcelWorkSheet$]
  </code></pre>
  
  <p>It says this SQL Statement is not a query. In fact, no other functions seem to work, such as COALESCE and even CAST.
  Does the SQL Server Import and Export Wizard not accept functions?</p>