Hi
I want to get the count of the column with specific value.
In the following example Ihave to know how many columns with 'Y' (value can be 'Y' or empty)

create cursor mycursor (yellow c(1), grin c(1), blue c(1),total i)
insert into mycursor (yellow,grin,blue) values ('','Y','Y')
insert into mycursor (yellow,grin,blue) values ('Y','','Y')
insert into mycursor (yellow,grin,blue) values ('Y','Y','Y')
insert into mycursor (yellow,grin,blue) values ('','Y','')
insert into mycursor (yellow,grin,blue) values ('Y','','Y')
insert into mycursor (yellow,grin,blue) values ('','Y','Y')
insert into mycursor (yellow,grin,blue) values ('Y','','')

select mycursor
scan
	replace mycursor.total with ?&&count of columns with 'Y' value (0/1/2/3)
endscan