Correct, we both assume that it is not empty and there are no other values.
>Neither one would work correctly if actioncode isn't C, U or D
>>
IIF(actioncode="C", "CREATED", IIF(actioncode="U", "Updated", IIF(actioncode="D", "Deleted", "Unknown")))
>>>
SUBSTR("CREATEDUpdatedDeleted", (AT(actioncode, "CUD")-1)*7+1,7)
>>>
>>>>I'm creating a view for a table. One column is called action type (Char 1) and has one of the following value: C,U,D. I want to create a column that if it is a C, then return CREATED, if its a U return Updated, and if it is a D return Deleted
>>>>
>>>>Can someone help me out with this?
>>>>
>>>>Thanks
>>>>Kirk
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison