Selecting date in the format of dd-MMM-yyyy

SELECT replace(convert(varchar(11),RevisedON,106),' ','-') AS [DD-Mon-YYYY]
from tblTest

for selecting date in the format of 11-Nov-2010