Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA96728 for ; Thu, 1 Jul 1999 14:18:13 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id OAA03277 for ; Thu, 1 Jul 1999 14:17:28 -0400 Received: by localhost with Microsoft MAPI; Thu, 1 Jul 1999 14:18:47 -0400 Message-ID: <01BEC3CC.A2260D20.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-sql@hub.org'" Subject: a little conversion problem. . . Date: Thu, 1 Jul 1999 14:18:44 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 Encoding: 23 TEXT hello all! i thought someone on this list might have trained their brain cells more than me. . . i have two tables -- one with a field called autoinv int4 that represents a service record, and another table with a field vinvnum varchar(20) that represents a vendor invoice number. if we had a subcontractor perform service, his/her vinvnum will be the same as the service record number (autoinv in the other table). i'd like to compare those two fields, and where they are equal i'd like to update another field (for all practical purposes, a field in the first table mentioned above with autoinv in it) with the value of -1. here is what i tried: update table1 set fieldtobeupdated = -1 where text(table1.autoinv) = table2.vinvnum; exhausts memory every time. closes back-end. no way jose' (sorry mr. soares -- you have to have heard that too many times!). would it work if i used varchar(text(table1.autoinv))?? or text(table1.autoinv)=text(table2.vinvnum)? i thought i'd ask here first before i tried -- if it bombs i bring 20 people and the business to its knees, and have to re-start postmaster. . . thanks for any help you can provide! jt kirkpatrick / mpsllc.com