On Sat, 7 May 2005 20:12:17 +0200, John Jaabæk <johnjaab@...> wrote:

> 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.

You can write % everywhere you want in a string constant of condition.
What is problem with LIKE?

Cheers,
--
Miroslav Penchev