Here is the challenge. Have a table with a column called NAME and the column contains both names of businesses and individuals. Business names are stored as is , example ABC Company. Individuals are stored as last name first name middle initial, example Public John Q. I need to get this information into another table where the biz name can be stored in the first name field no problem but I need to parse and individuals name so I can put the individual's first name in the first name column and their last name in the last name column.
Figure it out and I will send you a prize. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
