display/search values with pretended filter

[#1]

Hi

my first question is about the simply search funktion.

While I have connected to my database, I have many IDs:

How can I search like: ID500***<X<ID600***

X is my search filter, so I want to show up all IDs from ID500*** to ID600*** - for selecting them

My second question is about to use the filter in the Script:

I work mostly with the database, so i can only read.

How can I use the filter in the Script  for selecting pretended values ?

CONNECT TO Database1;

load "ID",

     "Name",

     "Birthday";

SQL SELECT *

FROM "Database1".db1."Customer";

[tresesco]

Try like:

CONNECT TO Database1;

load "ID",

     "Name",

     "Birthday";

SQL SELECT *

FROM "Database1".db1."Customer"  Where "ID" Like 'ID500%' or "ID" Like 'ID600%';

Update: Corrected

[jonathandienst · Accepted solution]

Might need to be

Where "ID" Like 'ID500%' or "ID" Like 'ID600%'

if you are using SQL Server

[tresesco]

Righ, just missed that. QV is in mind . Thanks Jonathan for the correction.