Initializing high-values

[Wynne]

Can anyone here tell me about initializing high-values?

I want to create a generic stored procedure that will perform the
following

Select * from ? where ? between parm1 and parm2

no problem, but when no parms are passed I want to perform a select *

so.......

In the declare section I set parm1 = null

I want to initialize parm2 to HIGH-VALUES, but I cannot find the
option. Last I used it was SQL SERVER 7.0

[David Portas]

SELECT *
FROM Sometable
WHERE col BETWEEN @parm1 AND @parm2
OR @parm1 IS NULL

--
David Portas
------------
Please reply only to the newsgroup
--

[Wynne]

"David Portas" <RE****************************@acm.org> wrote in message news:<4J********************@giganews.com>...

SELECT *
FROM Sometable
WHERE col BETWEEN @parm1 AND @parm2
OR @parm1 IS NULL

Thanks, you rock...I was focusing in the wrong direction.