12 Replies Latest reply on Aug 20, 2008 6:47 AM by Newsgroup_User

    Separate First/Last names from Field?

    newportri Level 1

      I have a table in which the first and last names are in one field (?) which I need to get into their own fields.

      I would create a new table:

      CREATE TABLE new_table
      SELECT #SpanExcluding(?, ?)# as last_name
      #SpanExcluding(?, ?)# as first_name
      FROM existing_table; ?

      Any help would be appreciated.