This looks like the problem....let's try it.

Greg

-----Original Message-----
From: LISTSERV list owners' forum
[mailto:[log in to unmask]]On Behalf Of Francoise Becker
Sent: Friday, March 10, 2000 11:29 AM
To: [log in to unmask]
Subject: Re: What I'm I doing wrong?


On 9 Mar 00, at 18:02, Gregory Juster wrote:

>
> SELECT itcust.custno as custno, custem, tempfn, tempsn
<snip>
> custno      custem                                             tempfn
> tempsn
> ----------- -------------------------------------------------- -----------
--
> -- ------------------------------
> 868383      [log in to unmask]                            AUGUST
> AKINS

Well, this goes back to my question of "are you sure custno is an
email address" and the answer is NO. The email address has to be
the first field unless you specify otherwise in the DBMS=.

Francoise