conditional select 1

[link9]

Can anyone help me out with some syntax on how to make a field in a returned dataset 1 if some condition is satisfied, or 0 if it's not???

ex)
SELECT col1, col2, (IF col1 >= col2 THEN 1 ELSE 0) AS condition
FROM table

Is that possible???

thx -
Paul Prewett

 

[Jerrycurl]

Something like this:

SELECT col1, col2, condition = CASE
WHEN col1 >= col2 THEN 1
ELSE 0
END
FROM table

 

[link9]

Boy, there are some stars flying today.

Thanks, buddy.