Re: Inserting a string with an Apostrophe
From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 04/29/04
- Next message: CB: "Re: Inserting a string with an Apostrophe"
- Previous message: CB: "Inserting a string with an Apostrophe"
- In reply to: CB: "Inserting a string with an Apostrophe"
- Next in thread: CB: "Re: Inserting a string with an Apostrophe"
- Reply: CB: "Re: Inserting a string with an Apostrophe"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Apr 2004 02:13:15 +0530
double up the single quote.
Insert into NAME (LASTNAME) Values ('D''Mario')
--
Vishal Parkar
vgparkar@yahoo.co.in
"CB" <anonymous@discussions.microsoft.com> wrote in message
news:2EB35DAE-25A4-4CA2-BE04-AA1FCD64F3BC@microsoft.com...
> I would like to insert a value with an apostrophe into a character
field. I keep on getting "commande text not set for command object". Is
there a character that I can put before and after the string to show that
the system should take the exact value and not look at the characters as an
indicator?
> EX: Insert into NAME (LASTNAME) Values ('D'Mario')
- Next message: CB: "Re: Inserting a string with an Apostrophe"
- Previous message: CB: "Inserting a string with an Apostrophe"
- In reply to: CB: "Inserting a string with an Apostrophe"
- Next in thread: CB: "Re: Inserting a string with an Apostrophe"
- Reply: CB: "Re: Inserting a string with an Apostrophe"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
- Re: firefox handling of apostrophe in www address?
... The quote marks around the URI can be single or double, ... ASCII apostrophe
and ASCII quotes. ... using %27 instead of ' in the HTML. ... ampersand character,
it's used as a delimiter between parameters. ... (Fedora) - Re: Real Meaning of Apostrophe?
... You can use the format ... If the apostrophe is seen as formatting, why
doesn't it get copied when I ... Special | Format to a cell that doesn't have one? ...
Returns the prefix character for the cell. ... (microsoft.public.excel.programming) - Re: Apostrophe Creating a Merge Problem
... One other thing you could try is to use a different character in your data, ...
> Excel file) in the particular Excel column that contains an apostrophe. ...
> SQL ... (microsoft.public.word.mailmerge.fields) - Re: equal sign substituted for apostrophe
... apostrophe, instead of being the character from the default paragraph font, ...
is a WP Typographic Symbols character. ... > One a couple of my workstations several
word documents are converting an ... > apostrophe to an equal sign when the document
is opened. ... (microsoft.public.word.application.errors) - Re: Interesting web site about kanji (in Japanese).
... >which come out as strange kanji, because the page doesn't bother to properly ...
standard code for an apostrophe and invented its own code. ... with the first having
the MSB on as a double-byte character. ... (sci.lang.japan)
