At 03:35 a.m. 11/12/2014, Rainer Hamann [email protected] [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 __________________________________________________________________
