Need to extract text information from a cursor and convert it into a varchar variable in SQL.

Cintek & Valleynet ( (no email) )
Fri, 18 Sep 1998 17:54:23 -0600

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">

This is an SQL problem we are having =and we were=20hoping that all of you Emerald experts would be getting pretty good at =your SQL=20commands and could lend us a hand. We need to process information from a =text=20cursor (cursor for incidents.description). In order to do this we have =to=20convert the text variable into a varchar variable in order to be able to =run=20string functions on it. We can easily convert a single text variable =into a=20varchar but we are unable to do the same with the information found =within a=20cursor. We will continue to hack away but if anyone has a solution we =would sure=20appreciate it. Thank you.
------=_NextPart_000_047B_01BDE32D.5E54EF60--