Thread: Sele

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    2
    Rep Power
    0

    Sele


    Hello,
    please could you tell me how to export from one expression to 2 variables, i explain:

    when i do : select champ1 from table1; the result is:

    row1 ==> value1@value2


    is there a solution to take value1 in variable1 and value2 in variable2

    ==> variable1 = value1
    variable2 = value2

    thank's a lot
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    158
    Rep Power
    10
    Read the manual about string functions, but if you need to process the values separately, why didn't you store them separately?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    2
    Rep Power
    0
    hi ,
    SPLIT_PART is useful in this case,
    case resolved

    thank's a lot

IMN logo majestic logo threadwatch logo seochat tools logo