Simple answer: If you have three pieces of data, then you have
three fields on the form.
You could split based on spaces, but if you have a first name
like "Mary Ann" or a last name like "Van Zandt", that just won't work.
-----Original Message-----
From: sas0riza [mailto:[EMAIL PROTECTED]
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 --------------------~-->
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/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/
