4 Replies Latest reply: Feb 21, 2010 3:15 PM by Mike_Watt RSS

    SQL Search for range of money

    Mike_Watt Community Member

      One of my search fields is for Amount Paid... it's a drop down and it has the following options:

       

      0-99

      100-499

      500-999

      1000-4999

      5000-9999

      10000 +

       

      The db column is DECIMAL (7,2)

       

      How would I structure that portion of the query to return data based on the range selected?