CONCAT DayofWeek Fields if Field Value =Y 3

[kernal]

Dayofweek Values in the fields
MON Y
TUE Y
WED N
THU Y
FRI N

IF MON='Y' THEN 'M'
IF TUE='Y' THEN 'T'
IF WED='Y' THEN 'W'
IF THU='Y THEN 'H'
IF FRI='Y' THEN 'F'

Results needed
MTH since MON,TUE and THU has 'Y'

Thank you for your help!

 

[johnherman]

SELECT
CASE
IF MON='Y'
THEN YOUR_STRING='M'
ELSE YOUR_STRING=''
IF TUE='Y'
THEN YOUR_STRING=YOUR_STRING || 'T'
IF WED='Y'
THEN YOUR_STRING=YOUR_STRING || 'W'
etc.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[carp]

SELECT DECODE(mon,'N',NULL,'M')||
       DECODE(tue,'N',NULL,'T')||
       DECODE(wed,'N',NULL,'W')||
       DECODE(thu,'N',NULL,'H')||
       DECODE(fri,'N',NULL,'F') AS schedule
  FROM Dayofweek;

 

[johnherman]

much nicer and more concise solution, carp - have a star!

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[kernal]

carp: Worked GREAT! Thank you