Taking out white space in string

Giganews Newsgroups
Subject: Taking out white space in string
Posted by:  ajet…@intervan.com (Ashlie)
Date: 8 Jul 2003

I am trying to develop a script that takes out the white space at the
FRONT and the BACK of a string but not the middle.  I have a string
that looks like this:

XXXX XXXX XXXX XXXX

The groupings within the string can be any length...however, in order
to dump this data into a SQL database, the potential added white space
at the front or the back of the string needs to be deleted as the user
moves from one text box in a form to the next.

Any ideas?

Replies