>IIF(TableName.FieldName='R','Referral','Request')

Or, you can do this in your Select Statement and put the values right into the cursor.

SELECT IIF(TableName.FieldName='R','Referral','Request ') AS fieldname...