User not known
Your message reads (in part):
Received: from walnut.iea-software.com (unverified [207.53.165.8]) by webserver.netsis.it
(EMWAC SMTPRS 0.83) with SMTP id <B0000173137@webserver.netsis.it>
Sat, 19 Sep 1998 02:10:18 +0200
Received: from walnut.iea-software.com (walnut.iea-software.com [207.53.165.8]) by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id za000944 for <emerald@iea-software.com> Fri, 18 Sep 1998 16:47:45 +0100
Received: from [204.244.154.4] by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id sjjaaaaa for <emerald@iea-software.com> Fri, 18 Sep 1998 16:47:43 +0100
Received: from station24 ([209.5.191.24])
by ns.cintek.com (8.8.5/8.8.5) with ESMTP id SAA16872
for <emerald@iea-software.com> Fri, 18 Sep 1998 18:19:07 -0600 (MDT)
Reply-To: "Cintek & Valleynet" <Support@cintek.com>
From: "Cintek & Valleynet" <Support@cintek.com>
To: <emerald@iea-software.com>
Subject: Need to extract text information from a cursor and convert it into a varchar variable in SQL.
Date: Fri, 18 Sep 1998 17:54:23 -0600
Message-ID: <047a01bde35f$a8ef5f60$18bf05d1@station24.cintek.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_047B_01BDE32D.5E54EF60"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
X-ListMember: filippo@netsis.it [emerald@iea-software.com]
This is a multi-part message in MIME format.
------=_NextPart_000_047B_01BDE32D.5E54EF60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
This is an SQL problem we are having and we were hoping that all of you =
Emerald experts would be getting pretty good at your SQL commands and =
could lend us a hand. We need to process information from a text cursor =
(cursor for incidents.description). In order to do this we have to =
convert the text variable into a varchar variable in order to be able to =
run string functions on it. We can easily convert a single text variable =
into a varchar but we are unable to do the same with the information =
found within a cursor. We will continue to hack away but if anyone has a =
solution we would sure appreciate it. Thank you.=20
------=_NextPart_000_047B_01BDE32D.5E54EF60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">