On Wed, Feb 16, 2005 at 10:09:05 -0800, Ray Madigan <[EMAIL PROTECTED]> wrote: > > Is there a way to count the number of null or not null columns in a row and > have an output column that has that count as the value?
One way to do this would be to create a CASE clause for each column that returns 1 or 0 depending on whether the column is null or not and add these expressions up. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
