‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Saturday, 29 May 2021 17:06, Adrian Klaver <adrian.klaver@aklaver.com> 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
ofwhich 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.