>I have a cursor as follows:
>
>field1 field2
>a .t.
>b .f.
>c .t.
>d .f.
>e .t.
>
>
>I would like to select field1 where field2 is .t. then store the selected field1 values in one string. In this example, the string would be "ace". My question is: is it possible to issue just one SQL-Select statement to achieve what I want? If so, please advise.
I don't think so. With GROUP BY you can combine results from several records in a group, including sums, but I don't think that string concatenation is possible. I suggest you write UDF, which you then invoke from the query.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)