5 Replies Latest reply on Jun 5, 2015 11:25 AM by Sanjaya Kumar Pradhan

    use of like(%) in sql in clause

    2960347

      hi all ,

      i want to write a select statement like below :

      select distinct col1 from table

      where coL1  IN ('B%','E%','G%')

       

      The data for col1 is not static hence i need to pick values which starts with B,E,G.

      Above sql is not working.

       

      Kindly suggest fix/alternate for above issue.