(no subject)

[Ruslan Zasukhin]

on 1/21/04 1:42 AM, Michael de Haan at mdeh at earthlink.net wrote:

> Ruslan,
> 
> Please help:
> 
> The following does not match:
> 
> SELECT cCode, cDesc, cVal FROM iCpts WHERE  cDesc  LIKE '\AOF BENIGN\Z'
> no_case
> 
> 
> but the following does:
> 
> 
> SELECT cCode, cDesc, cVal FROM iCpts WHERE  cDesc  LIKE 'OF BENIGN'
> no_case
> 
> Any insight?

Hi Michael,

The first will match only if you have record that contains value
EXACTLY as

    'OF BENIGN'    

But not e.g.

    'something OF BENIGN something'

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------