Mike Eghtebas
asked on
Line up function returned string...
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER