Re: [GENERAL] insert statment

Have you tried
Insert into product values('p001' , 'ASS\'Y' , 'o');
Greg

> Hello all!
>
> I have a insert statement and I found problem with it!
>
> The statement is:
> Insert into product values('p001' , 'ASS'Y' , 'o')
> The second field of the table is ASS'Y so the compiler found it is
> error!
> I can not change the data but wnat to change the quota ' to ~.
>
> so the insert statement should be :
> insert into product values(~p001~ , ~ASS'Y~ , ~o~ )
>
> I can not find the seting function for this environment change!
>
> How can I change it???
> Thank You in advance!
>
> sharon
>
>
>
> Sharon Chow
> ???
> Regaltronic
> MIS
> <sharon@