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) TThe column DamageNo is of type varchar and contains values such as '1542A111','0455E204','104702'...
-- pseudo code Select DamageNo, Case Cast(DamageNo As Integer) When -- no error occurred return the integer Else -- Return Null End As RequisitionNo from dbo.DamageInsertsHelp is deeply appreciated.