This follows my other two posts at
http://beyondrelational.com/blogs/madhivanan/archive/2011/05/03/sql-server-s-equivalent-of-oracle-functions-part-i.aspx http://beyondrelational.com/blogs/madhivanan/archive/2011/05/03/sql-server-s-equivalent-of-oracle-functions-part-ii.aspx

ORACLE		SQL Server

bfilename	Use OPENROWSET with BULK option

lag  		Join with the same table and get previous row value

Lead 		Join with the same table and get next row value

nvl		isnull

nvl2		CASE expression

decode		CASE expression

uid 		user_id()

median 		Refer this post 

trunc (numbers)	Round

trunc (dates)	Date functions like year(date), month(date), day(date) and Convert function with different date styles


extract		Date functions like year(date), month(date), day(date)

Remainder	Refer this post 

Keep following this and part IV will come shortly