UPDATE members set fullname = (SRPL(fullname, '(R)', (char(174)),0)) where lname exists and fullname contains '(R)'
" verses ' unless you changed your settings? Paul D -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Joan Peterson Sent: Monday, September 14, 2009 2:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Special Characters 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 >
