The individual replacement method using character 174 worked fine, but
there were several places where the change needed to be made (It
appeared in multiple columns), so I tried the command line UPDATE
TableName SET ColumnName = (SRPL(ColumnName, '(R)', (CHAR(174)), 0))
WHERE IDColumn = .vIDValue AND ColumnName CONTAINS '(R)', using " for my
quotes. Here is my code, and the error it produced:
UPDATE members set fullname = (SRPL(fullname, "(R)", (char(174)),0))
where lname exists and fullname contains "(R)"
-ERROR- Unrecognized command - retype it ( 40)
To test it, I used the SELECT command first, and it showed me the lines
to be changed; however, when I used the UPDATE command, I got the error
message. Any other thoughts?
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
