Quering one value in two fields with select

• Eduardo Reis-395309

  Grasshopper

  Points: 11

  More actions

  November 12, 2007 at 11:34 am

  #376970

  Hi,

  I have one value = 2691 and I need do a query to find it in two fields.

  Example

  cod liminf limsup

  1 0000000011

  2 0001200691

  3 0069201175

  4 0117602929

  5 0293003231

  6 0323203989

  In this case my result should = cod 4

  The value 2691 is between 1176 and 2929

  is there a function to do this?

  Thanks.

  Eduardo

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  November 12, 2007 at 11:38 am

  #750335

  SELECT

  cod

  FROM

  yourTable

  WHERE

  yourValue BETWEEN liminf AND limsup

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg