A. In Microsoft Access you would use:
Select iif(field>10,"large", "small") as Size from Table
With SQL Server, use the CASE command
SELECT Size =
CASE
WHEN field > 10 THEN "large"
ELSE "small"
END
from Table
See also, "Enabling .NET on SQL Server" and "More SQL Server Tools."
3 comments
Hide comments