Since I live in Norway, Scandinavia and having three letters you don't have
times 2, I'm really having fun doing searching the database. Divide by zero
when searching on Scandinavian letters. So I need to replace them with
wildcards. I know how. Simple procedure or UDF or done inside PHP. Wherever.
But which wildcards are to be used??

'%' - works as first charachter on the line. Not as number 2 or later.
'*' - does not work at all.
'?' - does not work at all.

LIKE is handling '%' as first character.
CONTAINING is handling none. It is a wildcard search, but not good enough.

Anybody got an idea???

--

John H. Jaabæk