>Hi,
>
>I am planning to change a field type in one of the tables from NUM 6,0 to INT. The reason is that when I make this database in SQL Server I would want this field/column to be Identity column. So in SQL Server it would have to be Int type. I currently use this field (in VFP) just like an Identity. I have a routine that sets and gets the latest value in a PK table. So each record in the table has a unique value. And no decimal is used.
>
>My question is (and I realize that not knowing the application it is difficult for anybody to answer definitively) is there a place in the code that such change would have a negative effect? Any suggestions would be greatly appreciated.


> is there a place in the code that such change would have a negative effect?
I cannot think of any place nor any negative effect, Dmitry