That looks so much better than the ugly CASE. Looks like it is time for me to lookup PARSENAME and REPLICATE. If I ever learned them, I forgot and have not used them. Excellent, new knowledge. Thanks.
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.