SQL Query wildcard

Classic Servoy
1

I have various records with strings in the style of Apple, Apple1, Apple2, etc. A search string of “Apple%” will bring them all up, including the “Apple” record.

Is there a syntax for excluding the “Apple” record and bring up only Apple1, Apple2, etc.?

Thanks.

2

Have created a loop to run through the records looking for records which equal the base, omitting them from the found set. Works.