0 Replies Latest reply on Dec 12, 2002 10:07 PM by CL Gilbert

    BETWEEN querys help needed

    CL Gilbert Newbie

      How do people implement those searches that ask for min and max values? I can do the sql for between. But the problem comes when 1 field is left blank. 1 null spoils the whole equation.

      How do you handle something like this

      SELECT * FROM table WHERE name BETWEEN x AND y;

      What happens when x is null, or y is null? Do I have to have 3 seperate sql statements? 1 for each possibility? This is a common search so I assume this problem has been solved. Whats the answer??

      Thanks!