`CASE` is available, but `IIF` might be better
http://msdn.microsoft.com/en-us/library/windowsazure/ee336248.aspx#logical
```sql
UPDATE dbo.ChatUsers SET BanStatus = IIF(IsBanned = '1', '1', '0')
```