Hallo all VFP-Professionals,

I've got this table:
*+------+-----+-----+-----+-----+..+-----+-----+..+-----+
*|cName_|iYear|t0101|t0102|t0103|..|t0131|t0201|..|t0631|
*|c(12)_|i____|c(2)_|c(2)_|c(2)_|..|c(2)_|c(2)_|..|c(2)_|
*+------+-----+-----+-----+-----+..+-----+-----+..+-----+
*|Daisy_|_2003|___HO|___HO|___HO|..
*|Donald|_2003|___HO|_____|
*|Mini__|_2003|___IL|___IL|
*|Mickey|_2003|___HO|___HO|
*|..

I look for a SQL- or xBASE-Code solution. I want to count the numbers of signs (HO=holiday,IL=ill,..) in the record. To get this table or cursor as answer:

|Name__|Year|Holiday|_Ill__|
+------+----+-------+------|
|Daisy_|2003|______3|_____0|
|Donald|2003|______1|_____0|
|Mini__|2003|______0|_____2|
|Mickey|2003|______2|_____0|

Many thanks for help from germany.