Re: Problem with ampreson(&)

Bhargav wrote:
>
> Hai,
>
> I want to insert some text with ampreson(&) value in a varchar2 field.
> Please help me out.
>
> Bye,
> Bhargav

I guess you are using Sqlplus and when you try something like:

insert into mytable values ('text&more');

...you're asked to fill in the &more part. This is because sqlplus interprets &... as sqlplus-variables. Solution:

insert into mytable values ('text'||chr(38)||'more);

-- 
Kjetil Skotheim
kjetilskotheim_at_iname.com