RE: Inserting an ampersand (&)

use the chr() function to insert any special characters into a table.  Simply concatenate the character to your existing strings and your all 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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul van Dijken
  INET: paul.vandijken_at_sema.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).