Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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";
Might need to be
Where "ID" Like 'ID500%' or "ID" Like 'ID600%'
if you are using SQL Server
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
Might need to be
Where "ID" Like 'ID500%' or "ID" Like 'ID600%'
if you are using SQL Server
Righ, just missed that. QV is in mind . Thanks Jonathan for the correction.