Try using (char(char_value)) and see if that works. I have had better luck at times. I recall (char(039))
Sincerely, Paul Dewey New Horizon Interlock Inc. New Horizon Safety Diagnostics Inc. www.interlockinfo.com Saving Lives - One Breath at A Time T IMPORTANT NOTICE: This electronic communication and any attachments may contain confidential information and may be legally privileged. It is intended solely for the addressee(s). Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offense. Please delete if obtained or received in error, and email confirmation to the sender. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Joan Peterson Sent: Monday, September 14, 2009 5:43 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Special Characters I have had several people with apostrophes in their names for years, back to the 80's, so I've been using the double quotes for a long time now. I tried both ways and still got the same message. Joan Paul wrote: > 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 >> >> > > > >
