<< Is there a way in an Extreme9 table to use special characters? I have several listings which include credentials initials, many of whom are registered. I have been using (R) for this symbol and have to convert it in any of the other programs I export to, in order for the Registered symbol to appear. Example: Smith, John F., CFP(R) >>
In the standard font encoding, the registered trademark symbol is character 174. Users can enter it directly by holding down ALT and typing 0174 on the numeric keypad. Alternatively, you can allow the users to continue entering (R) and then, after the record is saved, doing an UPDATE TableName SET ColumnName = (SRPL(ColumnName, '(R)', (CHAR(174)), 0)) WHERE IDColumn = .vIDValue AND ColumnName CONTAINS '(R)' Or you can offer both. -- Larry
