From: <>
Date: Mon, 3 Nov 2008 06:40:56 -0800 (PST)
Message-ID: <>

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

Original text of this message