Forum Stats

  • 3,769,586 Users
  • 2,252,984 Discussions
  • 7,875,105 Comments

Discussions

Display

3565381
3565381 Member Posts: 21
edited Jan 5, 2018 5:37AM in Big Data Connectors/Hadoop

How to display the names with starting letter with "J", "L", "M" at single program.

Thanks                   

3565381

Answers

  • BrunoVroman
    BrunoVroman Member Posts: 1,848 Silver Crown
    edited Jan 5, 2018 5:37AM

    Hello,

    you are most probably in a wrong forum. Seeing your other questions I think that you might simply want something like

    SELECT m.name

      FROM mytable m

      WHERE m.name LIKE 'J%'   

       OR m.name LIKE 'L%'  

      OR m.name LIKE 'M%'

    ;

    Alternative -but I prefer the first option-

    WHERE SUBSTR( m.name, 1, 1 ) IN ( 'J', 'L', 'M' )

    Best regards,

    Bruno Vroman.

    35653813565381
This discussion has been closed.