Hi,
I want to run a distinct query against a text field."something,
something else, etc, etc,"
I have got this far:
SELECT distinct (Summary), count( distinct (Summary)) FROM report
where
Cost> 1000 group by Summary;

But this is looking at whole text field, and I just want to use the
first portion of the comma separated text field.
I expect regexp_like is the solution but I cannot quite figure it
out!

I think just a few hints would help me crack this one!

TIA

Carlos