Thanks a lot, Larry.
Joan
Lawrence Lustig wrote:
<<
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
