Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  IIF-like behavior in views?

Author  Topic  alebey Starting Member 17 Posts Posted - 2001-08-03 : 15:24:13 I have a table with a bit field (let's call it FLD) in it, and I'm designing a view which uses that table. Now, I want the view to display different values based on the value of FLD. Something similar to: IIF(FLD=0, 'Big Yak', 'Small Yak') So, if FLD is False, it'd display "Big Yak", otherwise, it'd display "Small Yak". Thanks for your ideas! PS: It's a SQL Server 2000 view. Edited by - alebey on 08/03/2001 15:25:05