Results 1 to 2 of 2

Thread: IN Clause

  1. #1
    Join Date
    Jul 2001
    Location
    Southend-on-Sea/England
    Posts
    8

    Unanswered: IN Clause

    Does anybody know how long the a csv string be when using the following:-

    select myid from tablex where myid in(1,2,3,4,5)

    Cheers
    Tim

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Tim
    I am not aware of any actual limit. You can even say

    select *
    from table1
    where col1 in (select col1 from table2)

    Table2 can have any number of rows. I would not expect that query to run quickly, if you have a large number of entries in the list you are searching through, though. Hope this helps.

Posting Permissions

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