I have a ms-access table which has cents signs in several fields. After creating metadata via "create synonym", queries of the fields show question marks instead of the cents signs.

I know that the cents sign is not in the ascii-set, but is there still some way to get them to appear in query output?

The CTRAN function would be your best bet using ebcdic values for the translation

Hi InsideTGT,

You are right that there is no cent sign in ASCII. There is one in EBCIDIC. If you can run the report as an RPC on an MVS server, the cent signs can be displayed.

To continue on with the research, please let me know, where would you like the cents signs to be displayed?

Cheers,

Kerry

here is the ¢
the numeric character reference in html for ¢ is
(i'll make spaces between the chars so you can see it) & # 1 6 2 ;
a nice reference is;http://www.cs.tut.fi/~jkorpela/latin1/3.html
so in focus, you would treat it the same way you would treat a non-breaking-space;
&|nbsp; would escape the & and give you a blank
so...
&|#162; will give you the ¢
(nb: the nonbreakspace is also &|#160; )
voila.

This message has been edited. Last edited by: susannah,