String Comparison

rbuser

I have a report that does a complex calculation based on the item number
passed through a sql statement. How can I determine whether the value
starts with a given letter or number. If I were performing this in sql it
would look something like

ItemNumber like '9%'

Where ItemNumber is a column and I want to get all records that start with
the number nine (9).

nardmoseley

Sorry, I do not understand the question. You can specify search criteria
like that via the Data tab by using the Query Designer. Specify the Like
operator. Designate the criteria as AutoSearch if you want a dialog to be
displayed that enables the user to enter the search value.

The Report.AutoSearchFields[].SearchExpression will contain the value
entered by the user. The user only enters the 9, the % sign is generated by
the TdaSQL object that generated the SQL statement.


--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com