Convert Microsoft SQL date to display format

 Convert Microsoft SQL date to display format:               

select CONVERT(VARCHAR(11),<DATE FIELD NAME>,106)  from <TABLE>;

106 is the  DD Mon YYYY format or  16 Apr 2011"