The sql below returns something like:
Jack Smith <-- has orders
Robert Nissan <-- has orders
(in a combo box)
I want to line up <-- has orders portions in:
SQL.ExecQuery("SELECT CustomerID, FirstName + ' ' + LastName + ' ' +" &
" dbo.fnHasOrders (CustomerID) as CustName From tblCustomers")
by having variable number of blank spaces instead of just ' ' above.
Let's say if we start this string (<-- has orders) at 50th position. I know it possibly will not to be exactly in line but it will be good enough.