title: MS-access Pass-Through Query to SQL Server 2008 Adding Prefix
body: <p>I am hoping someone can point me in the right direction with this. I am relatively new to using pass-through queries but think I have a grip of the basics, I have come across a stumbling block however when trying to add a prefix to query result</p>
  
  <p>I have a select query which includes a line to convert a date into the financial year i.e 01/01/2018 would return 2017 as the result using the code below:</p>
  
  <pre><code>    [Created FY] = (CASE WHEN Month(create_date) IN (1, 2, 3) THEN DatePart(year,create_date)-1 ELSE DatePart(year,create_date) END),
  </code></pre>
  
  <p>I would like to add a prefix to the result so that it would read FY2017. The pass-through is running on SQL Server 2008. I have researched and so far have not come up with any resolutions.</p>
  
  <p>Any help with this conundrum would be greatly appreciated.</p>