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

[jda]

Of course you’re absolutely correct. I see that it does work now, sorry for the noise.

Thanks for your help.

Jon

> That particular query can’t work because there is no German word starting with a sharp s. When testing for a sharp s anywhere I get the opposite result: there is a result where none should be. Will do some more investigating.
> 
> On 08.11.2013, at 16:15, jda <jda at his.com> wrote:
> 
>> 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)?
> 
> Mit freundlichen Grüßen/Regards
> 
> Trixi Willius
> 
> http://www.mothsoftware.com