>Select DamageNo,Cast(RequisitionNo AS Integer) As RequisitionNo From >(Select DamageNo, > Case ISNUMERIC(DamageNo) > When 1 Then DamageNo > Else Null > End As RequisitionNo >from dbo.DamageInserts) T >>
>-- pseudo code > >Select DamageNo, > Case Cast(DamageNo As Integer) > When -- no error occurred return the integer > Else -- Return Null > End As RequisitionNo >from dbo.DamageInserts >>
Select DamageNo, CAST(Case WHEN ISNUMERIC(REPLACE(DamageNo,'E','_'))=1 Then DamageNo End AS INTEGER) As RequisitionNo from dbo.DamageInserts