Hi,

Anyone know of a better way to optimize
my query below so that the optimizer will
do a clustered index seek insteads of the
clustered index scan. Those commented out
code are those code that I test with.

In addition, is there any function to
convert datetime to numeric value
and vice versa

-- index on PD_INDEX pd_security(product_id)
select * from pd_security
where
--cast(exp_dt as datetime) = '9999-12-31'
--convert(char(10),exp_dt,21) = '9999-12-31'
exp_dt = cast('9999-12-31' as datetime)