05/07/02 +0100, you wrote:
>Seems to work in SQL Server 7 :O)
>
>
>-Original Message-
>From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
>Sent: 05 July 2002 16:55
>To: CF-Talk
>Subject: Re: Adding Values (SQL)
>
>
>No, something like this
>
>SELECT co
ly 05, 2002 11:54 AM
Subject: Re: Adding Values (SQL)
> No, something like this
>
> SELECT column1, column2 + 3 AS NewQty
> FROM tablename
> WHERE id = 2
__
This list and all House of Fusion resources hosted by CFHo
Sent: Friday, July 05, 2002 10:57 AM
Subject: RE: Adding Values (SQL)
> It should work exactly how you have it...It does for me.
>
> Jim Vosika
> http://www.tinyclick.com
> FREE URL Shortening!
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
&
Seems to work in SQL Server 7 :O)
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: 05 July 2002 16:55
To: CF-Talk
Subject: Re: Adding Values (SQL)
No, something like this
SELECT column1, column2 + 3 AS NewQty
FROM tablename
WHERE id = 2
- Original
It should work exactly how you have it...It does for me.
Jim Vosika
http://www.tinyclick.com
FREE URL Shortening!
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 10:37 AM
To: CF-Talk
Subject: Adding Values (SQL)
I don't have any
No, something like this
SELECT column1, column2 + 3 AS NewQty
FROM tablename
WHERE id = 2
- Original Message -
From: "Adrian Lynch" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, July 05, 2002 10:48 AM
Subject: RE: Adding Values (S
Are you looking to add 3 to all the values in col2?
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: 05 July 2002 16:37
To: CF-Talk
Subject: Adding Values (SQL)
I don't have any cheet sheets with me, but I need to do a simple query and
have an add
I don't have any cheet sheets with me, but I need to do a simple query and have an
addition statement in the SELECT statment of a query.
Something like:
SELECT, column1, column2 + 3 AS NewQty
FROM.
Basically column2 is a numeric value and I want to add a number to it and rename the
Column
8 matches
Mail list logo