Help needed in Select Query urgently!!! Please

Well in MOST seat numbers, the NUMBERS are the Rows, and the LETTERS are the seat (from the left).
However, Rows MAY not be sequential (as in YOUR case).
Since seats beginning with "9" are in the sixth row.
Anyways, what I would do is...

Select * 
from passenger_tbl 
where dyn_flt_alcd = 'FR'
and dyn_bcty = 'BLL'
and LPad (fname_seat1, 3, '0') Like '09%'
and dyn_flt_no = '000'
and dyn_flt_dt = '11/20/2011'
order by LPad (fname_seat1, 3, '0');

I also took the liberty of changing your Where clause to be more efficient.

Hi Sir,

I have problem now for a scenario

if the seat numbers are
12A
12B
12C
14B
17D
20D
31A
31E
32A
33A

I need to sort from 12B: from the given query if I execute it again gives
12A
12B
12C
14B
17D
20D
31A
31E
32A
33A

But what I need is from 12B :( Please help

Well in MOST seat numbers, the NUMBERS are the Rows, and the LETTERS are the seat (from the left).
However, Rows MAY not be sequential (as in YOUR case).
Since seats beginning with "9" are in the sixth row.
Anyways, what I would do is...

Select * 
from passenger_tbl 
where dyn_flt_alcd = 'FR'
and dyn_bcty = 'BLL'
and LPad (fname_seat1, 3, '0') Like '09%'
and dyn_flt_no = '000'
and dyn_flt_dt = '11/20/2011'
order by LPad (fname_seat1, 3, '0');

I also took the liberty of changing your Where clause to be more efficient.

Kindly explain bit more what exactly you are looking for. because I am not able to understand your case.

Another little long way to do is
I suggest you one thing, If you have control over adding columns to seat master table.
You add one numeric order_no column.
so when you update or insert seat number say 1A, YOU UPDATE ORDER_NO with 165 by some logic, for eg. here I am converting A TO ascii value that is 65.

So whenever you want to sort, join transaction table with seat master table then order by column order_no

Okay, try...

Select * 
from passenger_tbl 
where dyn_flt_alcd = 'FR'
and dyn_bcty = 'BLL'
and LPad (fname_seat1, 3, '0') >= '12B'
and dyn_flt_no = '000'
and dyn_flt_dt = '11/20/2011'
order by LPad (fname_seat1, 3, '0');