Results 1 to 4 of 4

Thread: separate data to two column in access

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    separate data to two column in access

    Hi all

    I have data in access call Name which has both last and first name like BOWSER, Mary Jo G can I separate them to two column like first and last name. they separate by ,

    thank you
    ________
    Toyota Camry Ts-01 Specifications
    Last edited by sql; 03-06-2011 at 01:24 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    SELECT left(name,instr(name,",")-1) as LastName, right(name,instr(name,",")+2)from table1

  3. #3
    Join Date
    Jul 2003
    Posts
    421
    Hi Mak:

    Thank you I got it, but I check my sql books, I don't find this function, where I can get it ?
    thank you
    ________
    TOYOTA 4500GT HISTORY
    Last edited by sql; 03-06-2011 at 01:24 AM.

  4. #4
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    click on ms-access help and search

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •