So I want to run a validation on an address line column (address_line_1) to see if it ONLY contains numeric value (eg house number).
can I do this using the isnumeric function on the column?
something like..
case when isnumeric(address_line_1) = 1 then 'fail' else 'pass' end as ADDR_1_NUM;
Am I on the right lines here? Thanks
