srbentley
asked on
Correct syntax for SQL between-like query
I am trying to structure a query in a stored proc to handle an incoming zip code as follows: zip comes in and I need to search rule table to see if the zip value is between a value in BeginRange column and EndRange column. So if 77400 comes in and a record exists where BeginRange column is 77890 and EndRange column is 77405, the record is found. I can't quite see how the BETWEEN clause would work? Can someone get me unstuck with the correct query syntax?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
WHERE @ZipValue BETWEEN @BeginRange and @EndRange
ASKER
I knew that BETWEEN could work with params, but I didn't know you could reverse things and use it with the column names. Thanks.