Re: using & in a string.

If you're not using replacement variables (beginning with an &) in SQLPLUS then you can simply issue the statement 'set scan off' before running the sql statement.

Rich

Patrick Joyal wrote in message <39900e91_at_news>...
>what's an escape command?
>
>Stefan Roesch wrote in message <398F1790.7EEEB42B_at_t-online.de>...
>>If you are executing this command from sqlplus than it is clear. The &
>>character is used as the beginning of a variable. If you want to enter
 this
>>character than you have to redefine this character with escape command
>>
>>Hope this helps
>>Stefan
>>
>>
>>Patrick Joyal wrote:
>>
>>> Hi,
>>>
>>> I have a string that says : 'Front & back'
>>> I want to insert that string into a table :
>>>
>>> Insert Into Table1 (Description) values ('Front & back') ;
>>>
>>> resulting in :
>>>
>>> old 1: Insert into table1 (Description) values ('Front & back') ;
>>> new 1: Insert into table1 (Description) values ('Front ') ;
>>>
>>> 1 row created.
>>>
>>> My questions are :
>>> 1- Why this is happening?
>>> 2- How can I avoid that?
>>>
>>> (I found something for question number 2, but let see if you can come
 with
>>> something better.)
>>>
>>> thanks
>>>
>>> Patrick
>>>
>>> --
>>>
>>> "She just love my big 10 inch
>>> record of her favorite blues" - S.T.
>>
>
>
Received on Wed Aug 09 2000 - 00:00:00 CDT