1 = kid
2 = house
3 = pants

Below is a sample of me program. Could anyone help me out?

sub divisions()

        division = "exec usp_rd_division"
        set Open_Record_Division = oConn.Execute(division)
        divisionss()
end sub

sub divisionss()
      Do while not Open_Record_Division.EOF

                If division = "'1'" then
                        division = "K"
                        Response.Write division
                elseif division = "'2'" then
                        division = "H"
                        Response.Write (division)
                elseif division = "'3'" then
                        division = "P"
                        Response.Write ("division")
                end if
                        Open_Record_Division.Movenext
      loop
end sub

Sent via Deja.com http://www.*-*-*.com/
Before you buy.

Example:
SELECT
  CASE Division
    WHEN '1' THEN 'k'
    WHEN '2' THEN 'h'
    WHEN '3' THEN 'p'
FROM
  Table

Hope this helps!

Ryan N.
______________
This is madness!!!