>if i add an index in the table designer and have an expresion such as
>

>adddate != date()
>

>Will the date() be considered Dynamic or constant?

date() will be correct for each day you access your table.