you need to convert your comparison dates instead of converting the date in the table

Like this:

declare @a varchar(12) = '14-03-2013'

select

@a, convert(date,substring(@a,charindex('-',@a)+1,2)+'/'+

left(@a,charindex('-',@a)-1)+'/'+

right(@a,charindex('-',reverse(@a))-1))