Posted by Kimmo Laine on 10/14/52 11:26

This is fucking ridiculous, but I can't seem to get this working.... I want
to use if-statement inside a query. I remember clearly that something like
this would actually work in MySQL, but so far I haven't got it working in
MSSQL.

Trying something like
"SELECT IF(dsum > 100, 100, dsum) as dsum_2 from view1"

Meaning, that if the particular row has dsum larger than 100, then output
100, but if it's less than 100, then output whatever dsum is. Doesn't work.
Parse errors are all I get. I'm basicly trying to select the smaller of 100
and dsum. dsum is something between 0...120.

Like this:
dataset | result of select
dsum | dsum_2
---------------
100 | 100
50 | 50
120 | 100
75 | 75
105 | 100


Thanks in advance

--
Welcome to Usenet! Please leave tolerance, understanding
and intelligence at the door. They aren't welcome here.
eternal piste erection miuku gmail piste com

[Back to original message]