Please Help.

[Guest_imported]

I am using cold fusion to create a table which will populate a database.&nbsp;&nbsp;One of the fields for first name has first name and middle initial inputted in it.&nbsp;&nbsp;(i.e. the field for first name could be &quot;Joe B.&quot.&nbsp;&nbsp;And unfortunately the DB has 2500 records, so manual changes are out of the question.&nbsp;&nbsp;How can I get cold fusion to select the first part of the field, to get just the first name.<br>

 

[davejoyce]

Use the string Handling functions such as SpanExcluding to span to the first space. This will be the first name.<br><br>See Ben Forta's Book Pg 883. <p>Dave Joyce<br><a href=mailtoaveJoyce@hotmail.com>DaveJoyce@hotmail.com</a><br><a href= > </a><br>