Omnis code database question

[Mark555]

I am having trouble writing a formula for a database.

This is the original formula that works,

con(pick (Name.COMPANY_RECORD
=1,mid(Name.LAST_NAME,1,6),mid(Name.COMPANY,1,6)),mid(Name.CITY,1,6)

This will return a string that looks at either the last name and the city
of the record if the record is a private individual or the company and
the city if the record is for a company.

I want to change it so the if the record is a private individual it will
return a string that is last name, first name and city.

I have tried,

con(pick (Name.COMPANY_RECORD
=1,jst(mid(Name.LAST_NAME,1,5),mid(Name.FIRST_NAME,1,1)),mid(Name.COMPANY,
1,5)),mid(Name.CITY,1,5))

but the 'jst' function doesn't seem to work and its not adding the first
name to the string. I have also tried a 'con' in place of the 'jst' but
the program will not accept it as a valid formula.

Does anyone have any suggestions??

Thanks for your help.