Yes, Just create the two new columns and do like you suggested, find the first space and insert the name into the firstname column and then copy the remaining length of the string into the lastname column minus the space. Then run a quick output to visually inspect the contents of the fields. It'll be a small pain to do but lesson learned: "never let the client define the database." :)
Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 >>> [EMAIL PROTECTED] 05/13/02 12:04PM >>> Hello cf-talk, I have an existing project where a form takes a field "name" and inserts in in a row "name" in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _____________________________________________________ Composed on Monday, May 13, 2002, at 11:55:57 AM ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
