[font="Verdana"]What is in your "udDistID(int,not null)"?

it sounds to me you are looking to replace a datetime column with an integer column. As a suggestion, try the following:

1. Rename the datetime column

2. Add a new column with the correct name and type (int not null, default 0).

3. Run a query to update the new column with the correct value.

If necessary, you can then drop the datetime column.

[/font]