Created On:  25 November 2011

Problem:

The requirement is to find ANY or ALL programs that start with a definable character string.  How can this be done in HyperView - Clipper?

Resolution:

The search is will be a basic search on ENTITY - PROGRAM, with the Attribute "Name" being "LIKE" a specific character string.  The attached example, does this search on any programs starting with the characters AR7, defined in the query as "AR7*"

In a list of programs containing the names AR7100, AR7200, AR7300 and AR0700, only the program AR0700 will NOT be returned.  This can be amended as required.

The Attached XML file can be imported directly into clipper for use.

Incident #2541618