Hi,

I was wondering if it is possible to order a recordset by specific values.

That is, I want my recordset to be ordered alphabetically, but I want to set the order of the alphabet.

For example, I don't want my recordset to be odered by A, B, C, D ...I want it to be ordered by G, V, T, A ... or something.

Can you do something like

etc

Thanks

s

Create a Table that holds the order you want:

CREATE TABLE [dbo].[MyOrder] (
    [MyField] [char] (1)
    [Order] [int]

Then insert your order data:
    T 3
    A 4
    B 5
    C 6
    G 1
    V 2
    Q 7
    X 8

Then join the 2 tables and order by the order column.
select mt.Myfield
from myTable mt
   inner join MyOrder mo ON mt.MyField = mo.MyField
order by mo.[order]

Thanks for your reply jbenson001. I ended up creating another column in the table and using that to order the results. It seems to work ok in this instance, but I'll keep your method in mind for future reference.