Using Functions In Views I.E. Trim or iif
Posted on 2007-12-06
Using SQL Server 2000, I want to add a new View, such as this:
SELECT Trim([Name]) From [tblData]
Select iif([Age] < 30, 'Young', 'Old') From tblAges
In the first case, it tells me unrecognized function, and in the second case, it tells me it doesn't recognize it doesn't recognize the Equal sign.