OT: Stupid SQL Problem (in oracle)

2002-09-10 Thread Edwards Robert (air0rae)
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

RE: Stupid SQL Problem (in oracle)

2002-09-10 Thread Alex Ninan
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

RE: Stupid SQL Problem (in oracle)

2002-09-10 Thread Andre Turrettini
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

RE: Stupid SQL Problem (in oracle)

2002-09-10 Thread SPANGLER ALAN L. (dal1als)
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

Re: Stupid SQL Problem (in oracle)

2002-09-10 Thread Tim Painter
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

RE: Stupid SQL Problem (in oracle)

2002-09-10 Thread Jim Vosika
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

RE: Stupid SQL Problem (in oracle)

2002-09-10 Thread Dan Haley
, 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

RE: Stupid SQL Problem (in oracle)

2002-09-10 Thread Matt Liotta
, 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

RE: Stupid SQL Problem (in oracle)

2002-09-10 Thread Joel Nath
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

RE: Stupid SQL Problem (in oracle)

2002-09-10 Thread Tony Weeg
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