Obtaining the name of the month in SQL

Q. How can I display the name of a month (JAN through DEC) in an SQL SELECT statement instead of the month number (1 through 12)?

A. One way is to use the CASE expression:

 Select CYYMMDD,
        Case Substr( Digits( CYYMMDD ), 4, 2 )
          When '01' Then 'JAN'
          When '02' Then 'FEB'
          When '03' Then 'MAR'
          When '04' Then 'APR'
          When '05' Then 'MAY'
          When '06' Then 'JUN'
          When '07' Then 'JUL'
          When '08' Then 'AUG'
          When '09' Then 'SEP'
          When '10' Then 'OCT'
          When '11' Then 'NOV'
          When '12' Then 'DEC'
          Else 'Uh Oh..Bad Data!'
        End
   From FileName 


Select CYYMMDD,
       Substr( '   JANFEBMARAPRJUNJULAUGSEPOCTNOVDEC' ),
       (Integer( Substr( Digits( CYYMMDD ), 4, 2 ) ) * 3 + 1 ), 3 ) 
From FileName 

[report a broken link by clicking here]