>So my problem is : (I want to get the difference in number of days when using the SPT cursor but the modification I want to do is on the cursor and not the expression used.)
>Is there a way to change the datatype of a field in the cursor?
>Is there any other simple way to tackle this problem?
>
>I can put some code before/after the creation of the cursor to solve this problem but I don't want to change the code where the comparision is used.
>
Check out the DatePart() function in SQL Books Online.
Insanity: Doing the same thing over and over and expecting different results.