title: cast varchar to integer in teradata
body: <p>I have a column which is defined as varchar(19). So it can have alpha-numeric values.I have cast it to integer. Simple casting will give overflow exception and if I am tring to format it as Z(9) or '999999999'  it shows error saying column has combination of  numeric, character  and GRAPHIC values</p>
  
  <p>I have another casting too for which the column is defined as decimal(13,3) and I need to convert it to integer..I am clue less here too.</p>
  
  <p>Any ideas guys??</p>