SHOW:
|
|
- or go back to the newest paste.
| 1 | SELECT CASE | |
| 2 | WHEN t.Name = 'Foo' THEN 'Bar' | |
| 3 | WHEN t.Name = 'Bar' THEN 'Foo' | |
| 4 | ELSE t.NAME | |
| 5 | - | FROM ( SELECT LEFT(Name, CHARINDEX('.', Name) - 1) FROM Computers ) t |
| 5 | + | FROM ( SELECT Name = LEFT(Name, CHARINDEX('.', Name) - 1) FROM Computers ) t |
