Re: Urgent question! How do I use and English pound symbol?

"Geekgirl" <violet1879NOviSPAM_at_aol.com.invalid> wrote in message news:0146ce5a.ec32bba7_at_usw-ex0109-070.remarq.com...
> I have a header which includes an English pound sign and I
> need to know how to insert it -
>
> My table header is for personal income, for example,
>
> under 15,000 (pounds), 15,000-29,000 (pounds), etc.
>
> Thanks for any help!!

[Quoted] Try (educated guess) chr(156). I think that's the ASCII character for the £ in Oracle's "mind".

If you have a PC, open a Notepad window and while holding down the "Alt" key, type 156 on the 10-key keypad and then release the keys. A £ should appear.

Anyway, to illustrate w/Oracle:

select chr(156) || to_char(10)
from dual;

Should give as a result:

£10

(Not sure though if SQL*Plus will actually display the special character correctly or not.)

I'll try it at work tomorrow in SQL*Plus and let you know what I find out. [Quoted] There's also a URL I have at work that points to a place online with a full ASCII chart that might help.

-Matt Received on Wed Jun 28 2000 - 00:00:00 CEST