| Subject | Re: [firebird-support] difference between like and containing |
|---|---|
| Author | John Jaabæk |
| Post date | 2005-05-07T17:57:41Z |
A HUGE difference between LIKE and CONTAINING is the usage of wildcard '%'.
You can use LIKE '%something' but you can not use CONTAINING '%something'. It
must be CONTAINIG 'something'.
CONTAINING seems to be a wildcardsearch by itself.
Since I live in Norway, Scandinavia and having three letters you don't have,
I'm really having fun doing searching the database. Divide by zero when
searching on Scandinavian letters.
You can use LIKE '%something' but you can not use CONTAINING '%something'. It
must be CONTAINIG 'something'.
CONTAINING seems to be a wildcardsearch by itself.
Since I live in Norway, Scandinavia and having three letters you don't have,
I'm really having fun doing searching the database. Divide by zero when
searching on Scandinavian letters.
On Thursday 05 May 2005 03:54, Grant Brown wrote:
> Hi all,
>
> Using D5 and FB 1.5
>
> Having a look at Helens book (pg 396)with regard to the key word "Like"
> and "Containing"
>
> I am trying to work out which is the better of the two to use.
>
> I am trying to give the users the ability to search on part words etc.
>
> Any thoughts anyone ?
--
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