InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 23:43:41 GMT20http://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxvchandm23:What about using modulus (%)? Like some flavor of the following:select replace(1234.4321 % 1 ,'0.','')Tue, 09 Aug 2011 11:31:38 GMTkrshttp://www.sqlservercentral.com/Forums/Topic529177-137-1.aspx[quote][b]vchandm23 (8/8/2011)[/b][hr]but is there a function that does this in SQL Server[/quote]Not in any version of SQL Server that I know of. You're pretty much stuck with doing the math like you did.Mon, 08 Aug 2011 22:03:53 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxIf you can't use convert(), you can always use cast(). BTW, I can't remember how floor() behaves for negative numbers, but I know there's a reason I end up using round() instead.Mon, 08 Aug 2011 21:36:44 GMTBruce W Cassidyhttp://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxi know i can do the floor() on a decimal number and then store that to a variable and subtract it from the original numberexample @a = 2.75@b = floor(2.75)@c = @a - @b (this gives me 0.75)but is there a function that does this in SQL ServerCheers,ChandraMon, 08 Aug 2011 20:16:02 GMTvchandm23http://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxi know i can do the floor() on a decimal number and then store that to a variable and subtract it from the original numberexample @a = 2.75@b = floor(2.75)@c = @a - @b (this gives me 0.75)but is there a function that does this in SQL ServerCheers,ChandraMon, 08 Aug 2011 20:15:08 GMTvchandm23http://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxWhat if i want the other value not the floor value ........... i mean if its 1234.4321 i want 4321 (values after the decimal place...)?Cheers,ChandraMon, 08 Aug 2011 19:54:23 GMTvchandm23http://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxNo problem and thanks for the feedback, Phil... I've made similar mistakes... just wanted to be sure...:)Wed, 09 Jul 2008 08:09:13 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxI'm sorry... I meant ROUND(YourValue, 0, 1)I apologize for my lack of proof-reading.Wed, 09 Jul 2008 07:54:48 GMTPhilPachahttp://www.sqlservercentral.com/Forums/Topic529177-137-1.aspx[quote][b]indraprakash (7/8/2008)[/b][hr]Hi,round function not gives proper output floor is right.[/quote]Ummmm.... why do you think that? Using the optional 3rd parameter of ROUND makes it behave like FLOOR but with more control, if you need it.Tue, 08 Jul 2008 22:53:26 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxHi,round function not gives proper output floor is right.Tue, 08 Jul 2008 22:18:40 GMTindraprakashhttp://www.sqlservercentral.com/Forums/Topic529177-137-1.aspx[quote][b]indraprakash (7/7/2008)[/b][hr]Note: We can't use convert function[/quote]The ROUND function with the truncate option is definately the way to go... but why is it that you can't use the CONVERT function?Tue, 08 Jul 2008 14:40:42 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxor, useROUND(YourValue, 1) (revised) I'm sorry... I meant ROUND(YourValue, 0, 1)I apologize for my lack of proof-reading.The non-zero 2nd parameter truncates the value, without changing the datatype.Tue, 08 Jul 2008 14:21:27 GMTPhilPachahttp://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxThanks,It is workingTue, 08 Jul 2008 05:31:26 GMTindraprakashhttp://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxFunction floor() does not work? :unsure:Tue, 08 Jul 2008 05:16:44 GMTralfikhttp://www.sqlservercentral.com/Forums/Topic529177-137-1.aspxHi All,I want to split integer part from decimal value e.g. i have a no is 12456324.254 and i want to the output is 12456324Note: We can't use convert functionMon, 07 Jul 2008 05:45:10 GMTindraprakash