-----Original Message-----
From:	Wayne Tomasi [mailto:wtomasi@mailcity.com]
Sent:	Wednesday, July 29, 1998 7:00 PM
To:	akaplan@interaccess.com
Subject:	HELP - write character '—' to forms/sql

Hi,
  Please do help me find a way to save a record with the character '—'
  (alt-1-6-5) in it.
  Is there a way of writing it on Forms 4.5 and SQL?
  Can I retrieve the same record with the character in question from the database?

Thanks.

-----Reply Message-----
Wayne,

You can use CHR(209) to represent the — character. So, if you want to say
"MA—ANA", you can do:

INSERT INTO table_a VALUES
('MA'||CHR(209)||'ANA');

Yes, you can retrieve the same record with no additional changes.

Best of luck,

-Ari Kaplan

Back to Ari Kaplan's Home Page Kaplan's Home Page