I have table with data a mixture of alpha and numeric, I'm trying to find the way to extract value only if it's numeric
case when PS.PSDcode2 in (' STATE','ON TWP') then 'NULL' else PS.PSDcode2 end as PSDcode2,
I will go with
NOT LIKE approach it works well for any data
Select * [Table_Name] WHERE PSDcode2 NOT LIKE '%[^0-9]%'