How can you use an ' in an update?

Article View: pl.comp.lang.vbasic

Article #105047

Back to pl.comp.lang.vbasic Previous Next

#105047

From: Donald Myers
Date: Tue, 26 Jun 2001 20:25

21 lines
1564 bytes

I am creating an SQL update statement (programmatically in VB) and I am
trying to insert a field which includes the ' character. This of courses is
the character that signifies the begin & ending of a string in SQL. I know
it can be done because the data in the database already has the ' character
in many records.

Example

Update archive set customer = 'joe video', description = 'some movie' where
num = 1234

Work's

Update archive set customer = 'joe's video', description = 'some movie'
where num = 1234

Doesn't work because the joe's has a ' and then everything is thrown off.

Is there a way to "force" this?

D Myers

Technical Details

Message-ID: <B75E6807.BA45%myers@speakeasy.org>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!news.man.torun.pl!news.icm.edu.pl!mimuw.edu.pl!news.mimuw.edu.pl!news.internetia.pl!skynet.be!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp07

Show Full Headers

Complete Article Headers

User-Agent: Microsoft-Entourage/9.0.2509
Date: Tue, 26 Jun 2001 16:25:43 -0400
Subject: How can you use an ' in an update?
From: Donald Myers <myers@speakeasy.org>
Message-ID: <B75E6807.BA45%myers@speakeasy.org>
Mime-version: 1.0
Newsgroups: microsoft.public.basic.other,microsoft.public.es.vb,microsoft.public.sqlserver.clients,microsoft.public.sqlserver.odbc,microsoft.public.sqlserver.server,microsoft.public.vb,microsoft.public.vb.database,microsoft.public.vb.database.ado,microsoft.public.vb.database.dao,microsoft.public.vb.database.odbc,pl.comp.lang.vbasic
NNTP-Posting-Host: 207.65.151.80
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!news.man.torun.pl!news.icm.edu.pl!mimuw.edu.pl!news.mimuw.edu.pl!news.internetia.pl!skynet.be!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp07
Lines: 1
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit