5 Replies Latest reply: Oct 23, 2013 2:38 AM by sofie zettergren RSS

    Filter column in a straight table

      Hi,

       

      I have an issue which I hope you can help me with. I have a straight table where one column is an ISBN number which is a specific code for a book. In the expression I have count of listenings to the specific books. The issue is that I want to filter ISBN number which have a specific serie (where 4 numbers in the ISBN number are the same) I have added below code in the script but I guess I have to add an expression aswell in the table?

       

      select p.ID as PROGRAM_ID, p.ISBN, p.NAME, roy.ID AS ROYALTY_ID, roy.CUSTOMER_ID, roy.FULL_EQUIVALENTS, roy.INSERT_DATE AS INSERT_DATE

      FROM bokilur.ROYALTY_DK roy

      JOIN bokilur.PROGRAM p ON roy.PROGRAM_ID=p.ID

      WHERE PUBLISHER LIKE '%Gyldendal%' AND ISBN LIKE '%0215%'

       

       

      Thanks!