Have one Visit type field, the data is different:

row 1: Initial assessment; Reassement; CCGMS; Insulin Teach; others(total 10 different terms)
row2: Insulin Teach;Hispanic Class I; etc
row3: Individual Visit;Hispanic Class I
row4: CCGMS

each term has number represent it.

How can I use sql to get number for different terms?
May be use CASE WHEN will be work?

This is sql code in crystal report. I am not sure can use Cursor to do it?

Thanks