‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Saturday, 29 May 2021 17:06, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote: > On 5/29/21 9:00 AM, Laura Smith wrote: > > > I did try "nulls last" but will give it another go, maybe I messed up on the ordering of clauses. > > Unless the fields you are ordering on contain NULLs I'm not sure how > this is going to deal with your issue. > Reading between the lines of the poster who suggested it, I'm guessing the suggestion was to add an "int" column, most of which is null except for numbers where needed for ordering and then having "order by vip_num_order,order by last_name" in my select clause.
