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