Hi:

I have a scenerio where I am making a select but I want to 'filter' the
results where I can present the results in a different way based on values
in the result set. Typically I would just make two sepperate selects and use
SQL to parse my data by returning two result sets but is it a better idea to
do a select * and then use Java to format the data?

Just trying to improve my methodologies.

Stefan