sql server - Removing letters (a-z) from select statement -


i have table

create table #test  (id int ,  value varchar(15)  )   insert #test    values(1,'10')   ,(2,'12')   ,(3, '1.3')   ,(4, 'no value')    select * #test  

when selecting don't want see record 4, mean records letters (no value , no data , (a-z) ).can 1 me here please.

to return rows value doesn't contain characters in range a-z

select *   #test  value not '%[a-za-z]%' collate latin1_general_bin