CREATE OR REPLACE VIEW `societe_propriete_vue` AS 
SELECT id_societe_propriete,propriete.propriete,
IF( `societe_propriete`.valeur REGEXP 'm$', REPLACE( `societe_propriete`.valeur, 'm', '' ),REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
		REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(`societe_propriete`.`valeur` USING utf8)
		,'M','')
		,'O','0')
		,'..','.')
		,'(','5')
		,'ç','9')
		,'à','0')
		,'?','.')
		,'0 à ','')
		,'~','')
		,'m','.')
		,'+','')
		,'-','')
		,';','.')
		,',','.')
		,' ,','.')
		) as valeur
	
FROM `societe_propriete`
INNER JOIN propriete ON propriete.id_propriete =societe_propriete.id_propriete 
WHERE propriete.type ='distance'
AND `societe_propriete`.`valeur` != ''
AND propriete.id_composant=3
GROUP BY `societe_propriete`.`valeur`
ORDER BY propriete.propriete, `societe_propriete`.`valeur`;