[thelist] CF Search problem

Hello,

I would create a new string column in the table and populate it with the
word that comes after "Book of ".

--Bert Szoghy

-----Original Message-----
From: Howell, Katie [mailto:Kathleen.Howell-1@kmail.ksc.nasa.gov]
Sent: 10 May 2000 4:39 AM
To: thelist@lists.evolt.org
Subject: [thelist] CF Search problem


Thanks for all the help on the textarea problem...now see if you can help me
with this:
My client has a database of books.  The book titles are stored as "Big Book
of Lists, The" or "Big Book of Lists, A"  with the The or the A at the end
of the string.  So, if a person enters "The Big...." or "A Big...." it
doesn't find the book.  Do I need to have him change the entries in the
database? or is there a way to strip off the The or A when it occurs at the
beginning of a string?  

I owe tips big time...but need my coffee first...

Thanks