Fichiers publics, 01 Nov 2017

eject_long_tel (XLSX)

Identifiant du fichier:: 00043964
Nom original:: eject_long_tel.xlsx
Type de fichier:: XLSX - Microsoft Excel (OpenXML)
Taille:: 106.4 KB
Envoyé le:: 01/11/2017 à 11:51
Vues:: 920 vues

Télécharger

Aperçu texte

a requete country colonne longueur quantité statut concatenation recherche statut base pr1 pr2 pr3 pr4 pr5 pr6
#N/A #N/A BE phone1_num 8 378  BE8 BE #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'BE'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A BE phone1_num 9 330  BE9 BE #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'BE'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A FR phone1_num 9 859  FR9 FR #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'FR'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A GB phone1_num 9 519  GB9 GB #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'GB'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A GB phone1_num 10 777  GB10 GB #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'GB'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A DE phone1_num 6 45  DE6 DE #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'DE'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A DE phone1_num 7 339  DE7 DE #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'DE'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A DE phone1_num 8 103  DE8 DE #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'DE'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A DE phone1_num 9 313  DE9 DE #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'DE'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A DE phone1_num 10 927  DE10 DE #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'DE'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A DE phone1_num 11 508  DE11 DE #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'DE'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A DE phone1_num 12 959  DE12 DE #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'DE'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A AT phone1_num 6 518  AT6 AT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'AT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A AT phone1_num 7 909  AT7 AT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'AT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A AT phone1_num 8 924  AT8 AT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'AT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A AT phone1_num 9 47  AT9 AT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'AT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A AT phone1_num 10 410  AT10 AT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'AT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A AT phone1_num 11 735  AT11 AT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'AT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A AT phone1_num 12 67  AT12 AT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'AT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A AT phone1_num 13 732  AT13 AT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'AT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A IT phone1_num 7 829  IT7 IT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'IT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A IT phone1_num 8 266  IT8 IT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'IT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A IT phone1_num 9 74  IT9 IT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'IT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A IT phone1_num 10 445  IT10 IT #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'IT'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A CH phone1_num 8 472  CH8 CH #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'CH'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A CH phone1_num 9 664  CH9 CH #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'CH'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A US phone1_num 10 793  US10 US #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'US'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A CA phone1_num 10 275  CA10 CA #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'CA'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A
#N/A #N/A ES phone1_num 9 656  ES9 ES #N/A "Select TRIM(LEADING ' ' FROM cls) TRIM(both ' ' FROM mail) TRIM(both ' ' FROM nom) TRIM(both ' ' FROM prenom) TRIM(both ' ' FROM adresse1) TRIM(both ' ' FROM adresse2) TRIM(both ' ' FROM state) TRIM(both ' ' FROM city) TRIM(both ' ' FROM zip) TRIM(both ' ' FROM country) TRIM(both ' ' FROM phone1_ind) TRIM(both ' ' FROM phone1_zero) TRIM(both ' ' FROM phone1_num) TRIM(both ' ' FROM phone2_ind) TRIM(both ' ' FROM phone2_zero) TRIM(both ' ' FROM phone2_num) TRIM(both ' ' FROM phone3_ind) TRIM(both ' ' FROM phone3_zero) TRIM(both ' ' FROM phone3_num) TRIM(both ' ' FROM fax_ind) TRIM(both ' ' FROM fax_zero) TRIM(both ' ' FROM fax_num) TRIM(both ' ' FROM sex) TRIM(both ' ' FROM top1) TRIM(both ' ' FROM top2) TRIM(both ' ' FROM login1) TRIM(both ' ' FROM login2) TRIM(both ' ' FROM id1) TRIM(both ' ' FROM id2) TRIM(both ' ' FROM id3) TRIM(both ' ' FROM info1) TRIM(both ' ' FROM info2) TRIM(both ' ' FROM categcustomer) TRIM(both ' ' FROM active_user) TRIM(both ' ' FROM newsletter) TRIM(both ' ' FROM job) TRIM(both ' ' FROM activity) TRIM(both ' ' FROM company) TRIM(both ' ' FROM company_size) TRIM(both ' ' FROM siren) TRIM(both ' ' FROM ets) TRIM(both ' ' FROM tva) TRIM(both ' ' FROM ape_naf) TRIM(both ' ' FROM grp2) TRIM(both ' ' FROM grp1) TRIM(both ' ' FROM class1) TRIM(both ' ' FROM profit_estim) TRIM(both ' ' FROM class2) TRIM(both ' ' FROM categ1) TRIM(both ' ' FROM categ2) TRIM(both ' ' FROM birthday) TRIM(both ' ' FROM actiontime1) TRIM(both ' ' FROM actiontime2) TRIM(both ' ' FROM actiontime3) TRIM(both ' ' FROM champscal1) TRIM(both ' ' FROM champscal2) TRIM(both ' ' FROM champscal3) TRIM(both ' ' FROM champscal4) TRIM(both ' ' FROM lienweb1) TRIM(both ' ' FROM lienweb2) TRIM(both ' ' FROM cde_gest) TRIM(both ' ' FROM extra1) TRIM(both ' ' FROM extra2) TRIM(both ' ' FROM extra3) TRIM(both ' ' FROM extra4) TRIM(both ' ' FROM extra5) TRIM(both ' ' FROM extra6) TRIM(both ' ' FROM extra7) TRIM(both ' ' FROM extra8) TRIM(both ' ' FROM extra9)
From ctc_sauve where " LENGTH( #N/A 'ES'  INTO OUTFILE 'C:\\dossier\\sousdossier\\soussousdossier\\eject\\ #N/A

Partager le fichier

Lien court vers la page de téléchargement du fichier:

Code HTML - Recopiez ce code pour partager votre fichier XLS sur un site Web:

Code BB-Code - Utilisez ce code pour partager votre tableau sur un forum Web compatible avec les tags BB:

Lien permanent vers la page de téléchargement du fichier:

Signaler un contenu illicite

eject_long_tel (XLSX)

Aperçu texte

Sur le même sujet..

Partager le fichier