Received: from localhost.localdomain (lsanca1-ar1-013-179.dsl.gtei.net [4.35.13.179]) by hub.org (8.10.1/8.10.1) with ESMTP id e7G6wJn11908; Wed, 16 Aug 2000 02:58:23 -0400 (EDT) Received: from francisco (lsanca1-ar1-012-112.dsl.gtei.net [4.35.12.112]) by localhost.localdomain (8.9.3/8.8.7) with SMTP id XAA12977; Tue, 15 Aug 2000 23:11:27 -0700 Message-ID: <000f01c0074f$4dcd87e0$700c2304@francisco> From: "Francisco Hernandez" To: , Subject: variables in SQL?? Date: Tue, 15 Aug 2000 23:57:54 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200008/330 anyone know if SQL has variables? what im trying to do is have a Sum of a colum.. as it goes forwards with the cursor.. like so: Price|Sum 5|5 4|9 10|19 2|21 7|28 i can do it in the accessing language.. like PHP, Python, Perl etc.. but i wanted to know if the actuall DB could do it? any ideas?