SQL server and SQL

[clyde]

Hi there

How can I use if in a sql statement for a MS SQL server.

Here is an example in and access database
SELECT iif([t.recMags] = "Blade","$500","%450"), t.recTyreMake, t.recValve
FROM tbltyres t;

The syntax might be wrong but it is the idea that counts ...

Thanks
Clyde