>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
>
look datediff() and dateadd()
>-- 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)
index pd_security (exp_dt)
select * from pd_security
where exp_dt = '99991231'