Can't do an indexed search for a German sharp s (ß)

[jda]

Hi Ruslan,

When I do this indexed search

      select * from myTable where (left([myField], 1) = 'ß')

I get no hits. Shouldn't this work (a REGEX, unindexed search works)?

Jon