• You need to use a simple trick:

    Fname:= LEFT(8,Fname + "--------")

    A similar expression can be build for Qty.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP