title: What could be the alternative of Format function in 2008?
body: <p>I am confused we have sql server 2008 on server but I have coded in 2012 and used FORMAT function which is not working there. What is the replacement for 2008 ? Please help we have very less time to deploy. </p>
  
  <pre><code>SET @ComplaintAutoGenCode = (
      SELECT FORMAT(GETDATE(), @OrgName + '/yy/MM/' + CAST(@MaxComplaintID AS VARCHAR))
  )
  </code></pre>