Re: SQL vraagje

Article View: be.comp.programming

Article #3690

Back to be.comp.programming Previous Next

#3690

From: Rene
Date: Mon, 10 Nov 2003 08:14

10 lines
1493 bytes

"Passero" <yanongena@pandora.be> schreef in bericht
news:g_vrb.14425$7%3.485441@phobos.telenet-ops.be...
> Het is een access db... dus het is waarschijnlijk ms sql. maar werkt niet
> met sql server

Ik weet niet of Access STRLEN / LEN en RIGHT functies kent, anders zou je
een update kunnen doen van veld = "C" + RIGHT (veld, LEN(veld)-1).

Anders kun je altijd nog (oudbollig ) export maken naar ASCII, snelle editor
(bijv. van MSVC++ maar geen notepad), zoek en vervang en importeren :-)

Technical Details

Message-ID: <vquia4fn33ot98@corp.supernews.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail

References:

<9eurb.14091$lL3.444535@phobos.telenet-ops.be> <dBurb.2238$%W3.18823@amstwist00> <g_vrb.14425$7%3.485441@phobos.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: 107324,f3ff54730288fb67
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,f3ff54730288fb67
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2003-11-10 00:16:09 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: "Rene" <no@spam.nl>
Newsgroups: be.comp.programming,nl.comp.programmeren
Subject: Re: SQL vraagje
Date: Mon, 10 Nov 2003 09:14:53 +0100
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <vquia4fn33ot98@corp.supernews.com>
References: <9eurb.14091$lL3.444535@phobos.telenet-ops.be> <dBurb.2238$%W3.18823@amstwist00> <g_vrb.14425$7%3.485441@phobos.telenet-ops.be>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Complaints-To: abuse@supernews.com
Lines: 13

Reply to Parent Message