Why not declare a user defined function for each constant required? This will work in SQL Server 2000 as well.

For example:

[font="Courier New"]CREATE FUNCTION Const_Address_Work()

RETURNS INT

AS

BEGIN

RETURN 1;

END;[/font]

Then simply use it like so:

[font="Courier New"]SELECT addr.Line1, addr.Line2, addr.City, addr.State,

addr.Zip

FROM Addresses addr

WHERE addr.AddressType = dbo.Const_Address_Work()[/font]

This has the added benefit that you can then view dependencies for this specific function/constant to see what other source code refers to it. Very useful if a business rule change will affect code using that constant.