SQL CASE Statement

Question

SQL CASE Statement

In SQL Server 2000, the following is possible:

CREATE FUNCTION getItemType  (@code varchar(18))
RETURNS int
AS
BEGIN
Declare @Type tinyint
Select @Type = case len(@code)
WHEN 12,14,17 THEN 1
WHEN 13,15,18 THEN 2
WHEN 8,10 THEN 3
ELSE  0
END
RETURN (@Type)
END

Thank.

0

sql sql-server case-statement sql-server-2000

Saif khan Dec 11. '08 at 12:21

source to share

3 answers

This should do it:

CREATE FUNCTION getItemType(@code VARCHAR(18))
RETURNS INT
AS
BEGIN
    RETURN CASE 
        WHEN LEN(@code) IN (12,14,17) THEN 1
        WHEN LEN(@code) IN (13,15,18) THEN 2
        WHEN LEN(@code) IN (8,100)    THEN 3
        ELSE  0
    END
END

+6

Dave markle Dec 11. '08 at 12:31

source to share

 try  
  SELECT CASE
           WHEN LEN(@gcode) IN(x, y, z) THEN a  
         END
 etc.

or you may need

SELECT CASE LEN(@gcode)  
         WHEN x THEN a  
         WHEN y THEN a  
       END

and etc.

Here's the link.

0

dkretz Dec 11. '08 at 12:25

source to share

keithwarren7 · Accepted Answer · 2008-12-11T00:28:46+0000

try this:

Select @Type = 
(select case 
WHEN len(@code) IN (12,14,17) THEN 1
WHEN len(@code) IN (13,15,18) THEN 2
WHEN len(@code) IN (8,10) THEN 3
ELSE  0
END)

SQL CASE Statement

More articles: