String Comparison
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).
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).
This discussion has been closed.
Comments
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
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com