Convert float to int 1

[siituser]

I'm trying to populate some extra data into a table but the columns don't match. I created the temp table from an excel spreadsheet. Now, in my select statement, I need to convert a OLDID field from float to int.

Anyone? Thanks

 

[nigelrivett]

convert(int,oldid) ?

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[siituser]

Oh - now that was easy! Thanks!