Date Function :
1. Return day of the week
SELECT DATENAME(dw, GETDATE())
OR
SELECT DATENAME(weekday, GETDATE())
OR
SELECT DATEPART(dw,GETDATE()) --- RETURNS INTEGER LIKE 6 FOR FRIDAY.
i.e Sunday.Monday etc
http://msdn.microsoft.com/en-us/library/ms174395.aspx
Formatting Currency :
cast a money field in SQL Server 2005 to format it
SELECT ‘£' + convert(varchar,cast(Price as money),-1) as Price FROM Products
Price
£194,950.00
