Results 1 to 3 of 3

Thread: Split A Text

  1. #1
    Join Date
    Jul 2009
    Posts
    11

    Unanswered: Split A Text

    hi,

    just want to know how to split this text string "HAROLD,VINCENT,MARY,JOY"

    and store it data into 4 variables namely name1, name2, name3 and name4

    name1 := HAROLD;
    name2 := VINCENT;
    name3 := MARY;
    name4 := JOY;

    in an SQL query?

    Thanks,

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    INSTR and SUBSTR functions might help.

  3. #3
    Join Date
    Jul 2009
    Posts
    11
    thanks for the help... got it..

Posting Permissions

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