Hi, collation is set to primary
search is done like:
WHERE Kunde->navn LIKE '%dnb%'

Record wanted to get is "DNB", but for this to work I need to remove the first %, so 'dnb%' will get the "DNB" record...
But if i want to get record "Kulturkirken Jakob - Oslo" and search for LIKE 'Jakob%" I get nothing... I have to start with 'Kultur...'

So how kan I really have a match/contain... that can do both...

shouldn't '%dnb%' give me record with "DNB" in it ?