Re: Help with "&"

TurkBear wrote:

> & is a special character in SqlPlus that indicates that a variable
> name follows it and, if no pre-set value for the variable exists, it
> prompts you for one.

        Right.

> >We are trying to do a simple update in a field.
> >UPDATE tablename set fileldname = "blah"
> >where fieldname = "blah blew & etal"
> >
> >It is returning a prompt to enter in a string for etal.
> >Is & a wildcard or something else in Oracle? Do I need a litoral symbol of
> >some kind?
> >I dont have much more info than that. And I do not know oracle. Sorry.
> >Thanks in advance

	You can enter in sqlplus :
	set scan off
	and the problem with the &  character will disappear ....

-- 
**********************************************
Ce n'est qu'en essayant continuellement qu'on
fini par reussir donc plus ca rate, plus on a 
de chance de reussir
**********************************************