title: Do we have any equivalent function in SQL SERVER for VAL() function of MS Access?
body: <p>I have got a problem while running the code Access Query directly in sql server which contains <code>VAL([CoLUMN_NAME])</code>. After googling alot I found a <code>CAST(COLUMN AS DATATYPE)</code> to replace <code>VAL()</code>.</p>
  
  <p>But When that column is Text type and if we write <code>VAL([COLUMN_NAME])</code> we are getting only the number part from that text. For Example the column has this value 45-A45 and used <code>VAL([COLUMN_NAME])</code> we will get only "4545".</p>
  
  <p>If we want to achive this in SQL SERVER how to do ?</p>