Rob, LOL! You are a helpful person and a kind soul!! Thank you. -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Rob Smith Sent: Monday, August 07, 2006 11:21 AM To: thelist at lists.evolt.org Subject: Re: [thelist] SQL Question - Drop the last charector of a string > Got it! A co-worker provided the clue: Good to know. Here I was attempting to compose an email about recursive CTE's and splitting up the sub headings by - to an unknown number of columns, then parsing the fields back together as one column name... Phew!!!