Home Forums Programming General Splitting a column into Fname Lname RE: Splitting a column into Fname Lname

  • In my humble opinion this will never work.

    Let's say somebody is called "Gert Jan Van den Berg"

    In this case hist first name is "Gert Jan" and his last name is "Van den Berg"

    I don't see how a routine that can split this up in a query.......

    Look for another solution. For example create a table with Fullname, first name and last name and then do some joining...... You could even get the "Van den" correct then....

    I think this is the only doable solution.....