Select one value as another

[LinuxKommy]

How would i select one value based on another? the table stores its value as "Y" or "N", but i want 1 or 0. if they were numbers, i could perform the operation much more easily.
if anyone can suggest a better way to do this operation, i'd love to hear it because i'm running out of ideas here.

the table stores the flag field and a quantity of items. An example would be:

Flag Stock# Qty
---- ------ ---
Y 560000 2
Y 570000 1
Y 580000 1

I want it to return 4. the grouping occurs on an orderno, and the where clause selects all rows with the flag set to "Y". but i need it to count the quantity in there too? how would i do that?

 

[PruSQLer]

Since you say you're grouping on ORDERNO, I think it's as simple as

Select Orderno, sum(Qty)
From Table
Where flag = 'Y'
Group by orderno

But the fact you want Y to be 1 and N to be zero is kind of confusing

 

[LinuxKommy]

thanks....i feel really stupid now...actually i was coming back to write a reply like that. It had just occurred to me!

i wanted Y=1 so that i could do sum(Flag*qty), but then i realized that i would select the "Y"'s only anyway.

thanks for your help, and please don't laugh

 

[PruSQLer]

No problem, we've all been there. Although some people won't admit it.