sql server (alternate): 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

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

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

[quoted text, click to view]