It is possible to write a query get all that record from a table where a certain field contains a numeric value?
something like "select street from tbladdress where street like '%0%' or street like '%1%' ect ect".Solution
declare @t table(street varchar(50))
insert into @t
select 'this address is 45/5, Some Road' union all
select 'this address is only text'
select street from @t
where street like '%[0-9]%'