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

[Rob Smith]

>I am really having fits over all of this.  ANY help would be
fantastic!!!!

I'd probably run two passes through this database table, it might make
it easier. The first pass would be to separate <heading>-<subheading
with anything -and I - mean anything-> into the sub heading field. The
second pass would be to do the left(MyField,len(MyField)-1) trick. 



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