Query pain - need help

[Former Member]

Hi @ll,

i got this query, but it does not work. Any idea ?

DECLARE @xyz nvarchar(1)

SELECT @xyz =  (SELECT T0.TreeType FROM OITM T0 WHERE T0.ItemCode = [%1])
SELECT CASE @xyz <> 'S' THEN '1' ELSE '2' END

Thanks Steffen

[former_member204969 · Accepted solution]

You have left a 'When'. Try this:

DECLARE @xyz nvarchar(1)
 
SELECT @xyz =  (SELECT T0.TreeType FROM OITM T0 WHERE T0.ItemCode = [%1])
SELECT CASE @xyz When  'S' THEN '1' ELSE '2' END

[Former Member · Accepted solution]

Many many thanks Istvan, i was searching about 30 min. I think i do not the the chars from a lot of chars.

Regards Steffen