JohnCorbin
Programmer
Hi gang...
If I have code like
SELECT
WHEN code ='A' | CODE = 'B' | CODE = 'C' THEN
more code here
OTHERWISE
more code here
END
does the line code ='A' | CODE = 'B' | CODE = 'C'
read the same as code ='A' or CODE = 'B' or CODE = 'C'
Is there another way to code this ... I was thinking of
SELECT
WHEN code = 'A' THEN
WHEN code = 'B' THEN
WHEN code = 'C' THEN
more code here
OTHERWISE
more code here
END
If I have code like
SELECT
WHEN code ='A' | CODE = 'B' | CODE = 'C' THEN
more code here
OTHERWISE
more code here
END
does the line code ='A' | CODE = 'B' | CODE = 'C'
read the same as code ='A' or CODE = 'B' or CODE = 'C'
Is there another way to code this ... I was thinking of
SELECT
WHEN code = 'A' THEN
WHEN code = 'B' THEN
WHEN code = 'C' THEN
more code here
OTHERWISE
more code here
END