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!