title: cast or convert varchar datatype to rowversion
body: <p>I am able to convert rowversion column in a table to varchar using below code</p>
  
  <pre><code>select CONVERT(VARCHAR, CONVERT(BINARY(8), roversion_col), 1) rwa from TBL
  </code></pre>
  
  <p>How do I convert it back to rowversion datatype?
  Is it NOT possible to do so?</p>
  
  <p>Update:<br>This should not be treated as duplicate with
  <a href="https://stackoverflow.com/questions/41014533/how-to-convert-timestamp-values-to-varchar-in-t-sql-as-ssms-does">How to convert TIMESTAMP values to VARCHAR in T-SQL as SSMS does?</a></p>
  
  <p>That question is about asking rowversion datatype to varchar.
  However, this question is vice-versa and wanted to get rowversion data using varchar.</p>