SQL Between using multiple rows from 2 colums (start and end)
Posted on 2014-03-10
I'm trying to pull data from a table and my where clause contains needs to contain a BETWEEN condition. Basically a Start code and an End code. Each Item that I'm pulling data can contain any number of lines in this table from 1 to over 600 lines. So, I need to be able to query the table when the user enters a code to look to see if it falls into a range that has been established (start and end). Each range varies in size.
Is there a way to check 600 lines to see if the code that was entered by the user falls into any of the ranges? I would like to avoid FETCH sql, because some of the code I still need to use in Access! But I'll take any help at this point too!!!! Thanks.