I need some way to convert a word into a number.
I know I've done it once before, but I can't remember what I did.
For example, I have a query that will return something like the following:
Machine1 Running
Machine2Running
Machine3Offline
Machine4Running
Machine5Offline
This should help you...
Select status, count(*)
from table
group by status
status = column name having data(Running etc...)
-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 12:18 PM
To: CF-Talk
Subject: OT: Stupid SQL
Use the decode function. DRE
-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 1:18 PM
To: CF-Talk
Subject: OT: Stupid SQL Problem (in oracle)
I need some way to convert a word into a number.
I know I've done it once
Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 2:18 PM
To: CF-Talk
Subject: OT: Stupid SQL Problem (in oracle)
I need some way to convert a word into a number.
I know I've done it once before, but I can't remember what I did.
For example, I
or Unknown text)
HTH,
Tim P.
- Original Message -
From: Edwards Robert (air0rae) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 3:17 PM
Subject: OT: Stupid SQL Problem (in oracle)
I need some way to convert a word into a number.
I know I've done
Use the GROUP BY function...
Jim Vosika
http://www.softwaresupermall.com
-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 2:18 PM
To: CF-Talk
Subject: OT: Stupid SQL Problem (in oracle)
I need some way to convert a word
,
count(*) total
Dan
-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 12:18 PM
To: CF-Talk
Subject: OT: Stupid SQL Problem (in oracle)
I need some way to convert a word into a number.
I know I've done it once
, 2002 12:18 PM
To: CF-Talk
Subject: OT: Stupid SQL Problem (in oracle)
I need some way to convert a word into a number.
I know I've done it once before, but I can't remember what I did.
For example, I have a query that will return something like the
following:
Machine1 Running
September 2002 5:18
To: CF-Talk
Subject: OT: Stupid SQL Problem (in oracle)
I need some way to convert a word into a number.
I know I've done it once before, but I can't remember what I did.
For example, I have a query that will return something like the following:
Machine1 Running
Machine2
PM
To: CF-Talk
Subject: OT: Stupid SQL Problem (in oracle)
I need some way to convert a word into a number.
I know I've done it once before, but I can't remember what I did.
For example, I have a query that will return something like the
following:
Machine1 Running
Machine2Running
10 matches
Mail list logo