Who can help me?
I have a tables of married couples that asking some treatmen.
The table has (also) columns ssn1,ssn2.
I have the folowing expression in the one of the indexes:

STR(MAX(ssn1,ssn2))+STR(MIN(ssn1,ssn2))

.
How can I get this index in cursor?
OR,
Why I get error message [function name is missing)] in the following code:

select STR(MAX(ssn1,ssn2))+STR(MIN(ssn1,ssn2)) from table

Thank you for answer
Chaim