Problem with Select statement

I have the following Select statement where I want to fetch rows from CustTable:

string strSQLName = “SELECT * FROM %1 WHERE %1.CustGroup == ‘TPE’ || %1.CustGroup == ‘GRP’”;

axRecord.ExecuteStmt(strSQLName);

But I only get back rows where CustGroup = TPE. I also want rows where CustGroup = GRP. What am I doing wrong?

The database is first to reference the system table that contains the column names of the large table to get the column names that is need to retrieve of the data. The record that were retrieved not grouped according to select statement.

Hi,

string strSQLName = “SELECT * FROM %1 WHERE (%1.CustGroup == ‘TPE’ or %1.CustGroup == ‘GRP’)”;

Hope this will work.