Link to home
Start Free TrialLog in
Avatar of srbentley
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
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
WHERE @ZipValue BETWEEN @BeginRange and @EndRange
Avatar of srbentley
srbentley

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.