ORDER BY Question (1 Viewer)

[DrZoidberg]

Hi, is there any way to do an order by, but specify that a particular value is listed last, or first.

E.g. ORDER BY t_name ASC ... but feature Simon first and not with the other names beginning with 'S'

Thanks.

 

[ejstefl]

The only way I can think of to do this would be to set up another field on your table. Name it SortOrder or something like that. Then you can put either letters or numbers in this field at the records you want to display first. Then, sort by the new field first, then the name field.

 

[DrZoidberg]

Ok, thanks!