hi friends,

can u plz give the query, to search a column which consists of
alphabets or alphanumeric values. But it should not display
the rows with only numbers. The column datatype is varchar2.

for e.g the bill_no column contains the values
'RAJ', 'JOHN', '12870', '2000', 'JOHN35'
the query should display only 'RAJ','JOHN','JOHN35'.


with thanks

by madhu