RE: Inserting an ampersand (&)

I have used the chr() function for some things, now I need to insert =B5 - the greek letter mu.

Anyone know a quick and easy way to find the ASCII value so I can use the chr() function
to insert this character into the database?

TIA,
Donna Maser
Oracle DBA

-----Original Message-----

From: William Rogge [mailto:William_Rogge_at_voltek.com] Sent: Monday, November 20, 2000 11:06 AM To: Multiple recipients of list ORACLE-L Subject: RE: Inserting an ampersand (&)

use the chr() function to insert any special characters into a table.=20  Simply concatenate the character to your existing strings and your all=20 set.

Some special characters:

	!	33
	"	34
	#	35
	$	36
	%	37
	&	38
	'	39
	(	40
	)	41
	*	42




-----Original Message-----

From:	Paul van Dijken [SMTP:paul.vandijken_at_sema.nl]
Sent:	Monday, November 20, 2000 10:00 AM
To:	Multiple recipients of list ORACLE-L
Subject:	Inserting an ampersand (&)

I know I should know, but I can't remember and I can't find it in the FM.

How do I insert an & sign into a table like .....values('mothers & daughters') ??

Thanx
Paul

The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on:

+44 (0)1753 534655, or email 'is_at_celltech.co.uk'

Celltech Group plc
216 Bath Road, Slough, SL1 4EN, Berkshire, UK

Registered Office as above. Registered in England No. 2159282 Received on Mon Nov 20 2000 - 14:49:08 CST