select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="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
select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="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
select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="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
select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="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
select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="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
select distinct CHAR_P_GENRE from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="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