This is a more SQL question, but how do you break apart a field? For instance, in a column, I have both first name, middle initial, and last name. (e.g. Mary J. Smith). How do I write the SQL so that it'll break apart the different parts of the name and then insert it into it's appropriate column?
Mary -> FirstName J -> MiddleInitial Smith -> LastName Any help is appreciated! Thanks! ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
