Dec 3, 2001 · Tek-Tips is the largest IT community on the Internet today! Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the …

Apr 4, 2006 · SQL Server MOD function? Thread starter icemel; Start date Apr 4, 2006; Status Not open for further ...

Mar 6, 2003 · 8 Mod 3 returns 2 21 mod 7 returns 0 21.9 mod 7 returns 1 It appears that you want to return the decimal portion of a number. Use the following to perform this operation. x - fix(x) …

May 4, 2004 · Tek-Tips is the largest IT community on the Internet today! Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the …

Mar 26, 2002 · Hello I have a public function setup as a module which appends a modulus 11 checkdigit to a number. The thing is I'm getting different results when the input is a number …

Jun 3, 2004 · The MOD function returns the remainder portion of a division operation. 10 Mod 5 returns 0 because 10/5 = 2 with a remainder of 0. 10 Mod 3 returns 1 because 10/3 = 3 with a …

Mar 26, 2003 · Hello, I have a crystal report that uses a function called mod. the function is used on a field called ID to convert the number. eg, number starts like 13423453 use mod function …

Jul 7, 2005 · Use convert function to change the column(s) that currently have text to varchar field and the query should work fine. I hope those specific columns are smaller than 8000 …

Nov 15, 2002 · Dear ; You can round off using the same function in this style. For two decimals; FLOOR(45.5454*100)/100 it will give you 45.54

Jul 15, 2001 · As such there is no function under SQL 7 which duplicates the val() function, If you need to find a Numeric value in a string then u can use CHARINDEX to find the starting …