Proper array 1

[ziggs]

I have to input hundreds of streets in the following select expert formula:

{DataWarehouse.Address} like "*" & "S MAIN" & "*" or
{DataWarehouse.Address} like "*" & "BELLEW" & "*" or
{DataWarehouse.Address} like "*" & "JEFFERSON" & "*"

Instead of coding out each "or" line is there an easier way to put in each street (S Main, Bellew, Jefferson)? BTW, I have to have the "*" before and after each street.

 

[lbass]

Create a separate report and insert a text box in the detail section in which you type everything EXCEPT the field {table.street} which you should select from your field list:

{DataWarehouse.Address} like '*' & '{table.street}' & '*' or

Be sure to use the single quotes. Then run the report and export it to text (wordpad or notepad), and then do a find: " and replace (enter nothing) to remove the double quotes. Then copy the results into report->selection formula->record.

-LB