Group: microsoft.public.sqlserver.tools · Group Profile · Search for 500000 in microsoft.public.sqlserver.tools
Author: stefan.jansen
Date: Jul 29, 2008 02:03
...thousand separators). Running the following queries SELECT CAST(5 AS NUMERIC(5,2)) / CAST(2 AS NUMERIC(5,2)) SELECT 5.0 / 2.0 SELECT CAST(5 AS float)/ CAST(2 AS float) Give me following results 2.50000000 2.500000 2,5 Only the last one gives me the result according to my regional settings. Anyone else experienced similar problems and/or now a solution to this problem. Stefan
|