Features Introduced in Ingres 9.3
DBMS Server Enhancements
Large Object Pattern Matching
The LIKE predicate, which performs pattern matching for character and Unicode data, is extended to support LONG VARCHAR and LONG NVARCHAR data.
In addition, the following pattern-matching predicates, which belong to the LIKE family of predicates, are included:
• BEGINNING
• CONTAINING
• ENDING
• SIMILAR TO (ANSI SQL), which supports regular expression pattern
All predicates in the LIKE family support the same string types, including LOBs, and support case-insensitive search (the keywords WITH CASE and WITHOUT CASE can be used in the ESCAPE clause of the predicate). They differ only in the patterns that they support.
For details, see the SQL Reference Guide.