[font="Courier New"]select floor(13.890)[/font] returns [font="Courier New"]13[/font], but just for fun, here are the results for a couple of variations in SQL 2000 (one difference from SQL 2005 is shown):

[font="Courier New"]select floor('13.890')[/font]

13.0

(SQL 2005 returns [font="Courier New"]13[/font], without the trailing [font="Courier New"].0[/font].)

[font="Courier New"]select floor("13.890")

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name '13.890'.[/font]

I thought [font="Courier New"]select floor('13.890')[/font] would return an error, but it looks like SQL Server does an implicit conversion from text to number type in order to allow the calculation.

Thanks,

webrunner