Re: [SQL] finding columns that have three or fewer distinct characters

2008-03-05 Thread Jeff Frost
On Wed, 5 Mar 2008, Osvaldo Rosario Kussama wrote: Jeff Frost escreveu: I've got an interesting one...I'm trying to find columns that have three or fewer distinct characters (for example, "aa"). Wondering if I need to write a function or if someone has an idea how to do it with built

Re: [SQL] finding columns that have three or fewer distinct characters

2008-03-05 Thread Osvaldo Rosario Kussama
Jeff Frost escreveu: I've got an interesting one...I'm trying to find columns that have three or fewer distinct characters (for example, "aa"). Wondering if I need to write a function or if someone has an idea how to do it with built in functions and/or pattern matching? I think the

Re: [SQL] finding columns that have three or fewer distinct characters

2008-03-05 Thread Colin Wetherbee
Jeff Frost wrote: I've got an interesting one...I'm trying to find columns that have three or fewer distinct characters (for example, "aa"). Wondering if I need to write a function or if someone has an idea how to do it with built in functions and/or pattern matching? I think the thi

[SQL] finding columns that have three or fewer distinct characters

2008-03-05 Thread Jeff Frost
I've got an interesting one...I'm trying to find columns that have three or fewer distinct characters (for example, "aa"). Wondering if I need to write a function or if someone has an idea how to do it with built in functions and/or pattern matching? I think the thing to do would be t