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 ?