Re: How do i Insert a ' mark?
From: Tom Mettling <mettling_at_pop.erols.com>
Date: 1996/09/11
Message-ID: <5171tc$fk1_at_test-sun.erols.com>#1/1
Date: 1996/09/11
Message-ID: <5171tc$fk1_at_test-sun.erols.com>#1/1
wizard_at_mrinc.com (John Matzen) wrote:
>Obviously, you cannot do this:
>
>insert into blah values ('John's Cart');
>
>So, how to I insert the "'" mark?
>
>Thanks!
>
You have to use the CHR function with the ASCII code for the character (in this
case, 96).
For your example it would be :
insert into blah values ('John'||chr(96)||'s Cart');
Received on Wed Sep 11 1996 - 00:00:00 CEST