column length, range of values and ........ decode???

From: Mike Cohen <mcohen_at_attbi.com>
Date: 24 Jan 2003 16:31:48 -0800
Message-ID: <9a742dd3.0301241631.4f284bb@posting.google.com>

Hi All,

I've been messing around with this issue all week and have now raised the white flag. I think I've been close, but I just can't seem to nail it.

I am pulling the length of a comment column: length(t1.d_comment)

Now, I want to group the results, thus if a column is less than 15 in length, it goes to group A, if it is between 16 and 49 characters, it is in group B, and if it is 50 or greater characters, it goes to group C. I then want to count how many rows are in each group. I think that using a DECODE and possibly a SIGN are in order, but I don't want to have a decode for each possible column length value. Any ideas?

Thanks Very Much In Advance,

Mike Received on Fri Jan 24 2003 - 18:31:48 CST