>>I have 250 records in a database called timep.
>>Each record has 100 fields called p1,p2,p3 ..... p100
>>
>>Is there a global search i can do for a tally of the numbers of times the symbol "|" appears in the whole database - without having to count through each field of each record - ie without using scan or for-endfor. ie one or two lines of code.
>>
>>thanks for any suggestions
>>k
>
>Try a few things:
>
>select * from myTable where p1 like '%|%' or p2 like '%I%' or ...
>
>SELECT p1 from myTable where p1 LIKE '%|%'
>UNION ALL
>SELECT p2 from myTable where p2 LIKE '%|%'
>etc.
>
>
>
tnx naomi for suggestions.
k