There is no MOD function in SQL Server; % is the modulus operator

select Mod_Test = 100 % 60, VER = left(@@version,60)

Results:

Mod_Test VER

----------- ------------------------------------------------------------

40 Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)

(1 row(s) affected)