select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where  BE_A_CATALOGUE="1" AND CONCAT_COLLECTION like "2 %" || CONCAT_COLLECTION like "% 2" || CONCAT_COLLECTION like "2" || CONCAT_COLLECTION like "% 2 %" 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where  BE_A_CATALOGUE="1" AND CONCAT_COLLECTION like "3 %" || CONCAT_COLLECTION like "% 3" || CONCAT_COLLECTION like "3" || CONCAT_COLLECTION like "% 3 %" 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where  BE_A_CATALOGUE="1" AND CONCAT_COLLECTION like "4 %" || CONCAT_COLLECTION like "% 4" || CONCAT_COLLECTION like "4" || CONCAT_COLLECTION like "% 4 %" 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where  BE_A_CATALOGUE="1" AND CONCAT_COLLECTION like "5 %" || CONCAT_COLLECTION like "% 5" || CONCAT_COLLECTION like "5" || CONCAT_COLLECTION like "% 5 %" 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where  BE_A_CATALOGUE="1" AND CONCAT_COLLECTION like "31 %" || CONCAT_COLLECTION like "% 31" || CONCAT_COLLECTION like "31" || CONCAT_COLLECTION like "% 31 %" 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where  BE_A_CATALOGUE="1" AND CONCAT_COLLECTION like "40 %" || CONCAT_COLLECTION like "% 40" || CONCAT_COLLECTION like "40" || CONCAT_COLLECTION like "% 40 %" 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>