Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why error out in 'less Than Sign'
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Why error out in 'less Than Sign'
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01323151
Message ID:
01323151
Views:
72
Hi all,

Can somebody explain why I got error in here,

declare @price as int
set @price = 5
SELECT iif( @price < 0 , 'red', 'black' )


Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '<'.
Gregorio J. Placeres
IT Analyst
Uniform Accounting Network
Auditor of State of Ohio
88 East Broad Street
P.O. Box 1140
Columbus, Ohio 43216-1140

Tel. 614-728-4694

Gregorio_J@MSN.COM

http://www.gjpproductions.com
Next
Reply
Map
View

Click here to load this message in the networking platform