in my table i have two fields named l_series and h_series text. now i got a value of say some thing like st101 which should be b/w l_series and h_series how can i made a select query of this.

Maybe you can restate your question? What does b/w mean? To me it means "black & white"? Maybe it means "between". Do you mean that you want a query that returns rows where "st101" is between the values of l&h_series??

Don Arnett, thats my question as you said: where "st101" is between the values of l&h_series?

my guess would be something like this, where X is a variable. select * from your_table where 'X' is between l_series and h_series;

Of if your version of SQL doesn't support "between": select * from table where X >= l_series and X <= h_series;