Select * from AUDIT_HEADER
where type like ('SC%') and INV_REF_NUMERIC is NULL
set INV_REF_NUMERIC = (select CASE WHEN ISNUMERIC('Inv_ref') = 1 THEN CAST('Inv_ref' AS INT) ELSE NULL END)
how do I get any number only that exists in INV_REF (varchar (30) and put it into INV_REF_NUMERIC (int)
this doesnt seem to work?