date formate

Your Feild is Declare ExpDate varchar(15) then you can convert and cast below formate

set dateformat dmy  
Select CONVERT(varchar(15),Cast (ExpDate as datetime),106) as date from ExpenseTable

Output:
26 Aug 2012