Split the Name field into First and Last name - Cold Fusion, Allaire

Ever want to take the name field in your table and turn it into first_name , last_name fields? Read on... This script alters a database table to add two new fields, First name and Last name, it then takes the "Name" field's data and rips out the first name and last name to insert into the database.