At 03:35 a.m. 11/12/2014, Rainer Hamann rainer@... [firebird-support] wrote:

>"where name like 'Ab%'" returns any entry of the table, where name start with "Ab" except those ones containing character "-". Using "starting with" or "containing" the same database entries are missing.

It is unclear from your description what characters you are passing in the arguments for STARTING WITH and CONTAINING. Are you aware that the "%" wildcard is applicable only to LIKE?

e.g., if you pass

WHERE NAME STARTING WITH 'Ab%'

or

WHERE NAME CONTAINING 'Ab%'

then names such as 'Absalom' or 'Abdominal' will not be returned, because the "%" character is treated as a literal.

However, your WHERE NAME LIKE 'Ab%' should return names containing literal hyphens. Are you sure the data you expect is in "camel caps"? These arguments are case-sensitive. Perhaps the missing items are e.g. 'AB-Falafel'.


Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________