Hi Girish,
You didn't mentioned table name and column name so I named it
Table1
and named column
name
.
About your first question :
"i want to select values between 10 and A10.5, how can i achieve it?"
You can use this query :
select * from Table1 where name between '10' and 'A10.5'
And about your comment :
"atleast how to select values starting with alphabets..."
You can use this one :
select * from Table1 where name between 'A' and 'Z'
Hope it helps.