Case statement error

[n36z]

When I run the following query. An error is being thrown "Incorrect syntax near 'columnA'"

declare @value1 int
set @value1=2

select *
from table1
where 0 = 0

AND
CASE
WHEN @value1>1 columnA
ELSE 1
END = 1

 

[KH75]

you forget THEN befor columnA

 

[Qik3Coder]

SELECT * 
FROM table1
WHERE 0 = 0
[tab]1 = AND CASE WHEN @value1 > 1 [!]THEN[/!] columnA ELSE 1 END

Lodlaiden


I haz all the letters: SME, BA, QA, PM, DEV, DBA, UAT, SE, HD

 

[KH75]

declare @value1 int
set @value1=2

select * from table1 where 1 =
CASE
WHEN @value1>1
then columnA
ELSE 1
END

 

[bborissov]

WHERE 0 = 0 AND
      (columnA = 1 OR @value1 < 1)

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[n36z]

Thank You