• I thought it was common knowledge/best practice to always put text columns last. No one is saying we should rearrange the table design at all, just explicitly select like this

    select SalesID, SalesDesc, SalesAmmount, SalesComments from...

    Also I would rename the SalesAmmount column to the correctly spelled SalesAmount


    Michael R. Schmidt
    Developer