I've got a simple LIKE query on sql server that returns no result when the leading character is the same as the first...

Database tale contains a row with the field 'Lastname' and the value 'Aalesund'

```
select * 
from table 
where LastName like 'A%' -- returns no results

```

if I change the 'Lastname' field to contain 'Alesund' the exact same query returns the correct row.

Any ideas?

Stig