* FactOwner Name formatting in fact based query

[Little.auk]

Can somebody please tell me what I am doing wrong here, I am trying to edit a Factowner name expression to display Surname first with the following expression.

=Field(FactOwner(%FACT%,1,MALES_FIRST),'INDI.NAME:SURNAME_FIRST')

I have added :SURNAME_FIRST to an existing expression, the Query editor is accepting it as a valid expression, but running the query still returns Given Names Surname.

Ideally I would like the surname in capitals, but getting it to display first would be an achievement.

[tatewise]

Check out FHUG Knowledge Base An Overview of Queries and near the end under Sorting a Fact Query on Owner Surname there are all the answers.

There is an important distinction between the =Field(...) and =FieldText(...) functions.