SQL SERVER – Using Decode in SQL Server | Journey to SQL Authority with Pinal Dave
One of the reader of the blog has sent me question regarding how to use DECODE function in SQL Server. SELECT DECODE(Letters, 'First',1, 'Second',2, 'Third',3, 0) AS LN FROM LettersTable In SQL Server the equivalent code is CASE statement. Here is the ......