Search results for query: *

Yes...not sure if the syntax is correct for adding the date range...it differed from your example.

I'm guessing it has something to do with the range, as I receive this error message ("Failed to Retrieve Data from the Database") when I try to run a query that is too broad...when I minimize the scope (ie. data range) the query runs fine. Here is the query I'm trying to run which fails...

Thanks lbass: I tried it which seemed to work but the table is soo large that the query fails. I have a date field which I can query...how can I incorporate a date spread into this formula? Thanks TeyBrady: I don't have direct access to the Informix database, nor can I run direct SQL queries...

Sorry lbass, I'm trying to filter my selection by records that include credit card numbers or a string of 8 or more numbers included in a text field. The table has an exorbinate amount of records and I need to quickly list the records with possible credit card numbers in them for review. Does...

Thanks lbass! I tried your suggestion but got an error message when trying to add it to the query; "A boolean is expected" then the first line is highlighted. I need some real help here...

Ideally. I'd like to use a statement similar to: WHERE column LIKE '%[0-9][0-9][0-9][0-9][- ][0-9][0-9][0-9][0-9][- ][0-9][0-9][0-9][0-9][- ][0-9][0-9][0-9][0-9]%' but not sure if this is possible with Crystal Reports. Please HELP!

I have a real problem trying to filter fields from an Informix Database with CR11. I need to locate credit card numbers in a text field in multiple variations (####-####-####-####, #################, etc.) I've tried a lot of different methods to filter the results by locating a series of...