[thelist] SQL Question - Drop the last charector of a string

[Rob Smith]

> 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!!!

Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236