Well, try this and see what kind of result you get:

Select * from your_table where your_field Like '%m';

Select * from your_table where your_field Like '%m%';

Select * from your_table where your_field Like 'm%';

I'm having a database of companies around the world and among them is
'Norsk Hydro' with sub companies like 'Hydro Porsgrunn', 'Hydro Østland',
'Hydro Vestland', 'Hydro Nordland', 'Hydro Sørland'.

Give it a try:.....

On Saturday 07 May 2005 20:22, Miroslav Penchev wrote:
> 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,

--

John H. Jaabæk
tlf. +47 915 24 599
Uavhengig Velværekonsulent for Nikken
http://www.nikken.com
http://www.nikkenuk.com
http://www.5pillars.com