Thread: String Records

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

    Join Date
    Dec 2012
    Posts
    1
    Rep Power
    0

    String Records


    Hello
    I would like to ask for help. I do not know how to write a query to a database that records marked I want to search for a string of records in col1 from col2 (highlight it wants and how it does not find that the lack of communication drew within. Number of records in col2 will increase or decrease. Thanks in advance for any answers.

    my table:

    col1
    ------
    1
    2
    3
    4
    5

    4
    5
    6
    7
    5
    4
    5
    6
    7
    1
    2
    3
    4
    5

    7
    6
    4
    8

    col2
    -----
    1
    2
    3
    4
    5

    I need result to be

    col1
    ------
    1
    2
    3
    4
    5
    1
    2
    3
    4
    5
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,120
    Rep Power
    4274

IMN logo majestic logo threadwatch logo seochat tools logo