Date: Mon, 3 Nov 2008 06:40:56 -0800 (PST)
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 Received on Mon Nov 03 2008 - 08:40:56 CST