>Hi all,
>
>Can somebody explain why I got error in here,
>
>declare @price as int
>set @price = 5
>SELECT iif( @price < 0 , 'red', 'black' )
>
Where is no IIF in SQL Server. Use CASE construct instead.
See
http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping
If it's not broken, fix it until it is.
My Blog 
