Creating A Feild When Selecting

I have a database with tables with the following schema...

Articles) ArticleID, Version
ArticlesVersions)ArticleID Version Title Body etc...

I use the articles table to simply map to a version. This allows for me to revert the article to a earliar version.

I want to cache all the articles including the versions, but with another feild that needs to be created durring the select to determine wether the article version is the active version. The feild needs to be a bit (boolean).

I was thinking maybe SELECT (IF test = test THEN 1 ELSE 0 END) as IsCurrent.

I've tried doing this but I can't get it to work.

Any help would be appreciated!


SELECT dbo.mw_Articles.ArticleID, dbo.mw_ArticlesVersions.Version, dbo.mw_ArticlesVersions.Body, dbo.mw_ArticlesVersions.Title, dbo.mw_ArticlesVersions.ParentID,

dbo.mw_ArticlesVersions.Approved, dbo.mw_ArticlesVersions.UserName, dbo.mw_ArticlesVersions.UserID, dbo.mw_ArticlesVersions.Importance, dbo.mw_ArticlesVersions.EditNotes, dbo.mw_ArticlesVersions.TIME

FROM dbo.mw_Articles INNER JOIN

dbo.mw_ArticlesVersions ON dbo.mw_Articles.ArticleID = dbo.mw_ArticlesVersions.ArticleID AND

dbo.mw_ArticlesVersions.Approved = 1