Yes,
cast(myField as N(10,2) NULL) as MyNewField, cast(myExistingField as C(10) NULL) as myField
>Yes, that's what I had before I started trying to troubleshoot this other problem :)
>
>Which in reference to all I can say is groan, dumb, dumb, dumb, 50 lashes for me. There is of course 2 databases. A real one and a testing one, and of course I was editing one and running the other. Sorry about that. So now that I have that resolved, I have a new problem. CAn you create a cursor via a SELECT that will allow nulls? as in
If it's not broken, fix it until it is.
My Blog