SQL SERVEUR

Remplacer :

Update [dbo].[ARTICLES] set [ARTDESIGNATION] = replace([ARTDESIGNATION],’;’,’,’) where [ARTDESIGNATION] like ‘%;%’

Rechercher :

select [ARTCODE] from [dbo].[ARTICLES] where [ARTDESIGNATION] like ‘%;%’

ACCESS

Remplacer :

UPDATE ElementDef SET ElementDef.Code = Replace([ElementDef]![Code],Chr(34),Chr(45));

UPDATE ElementCompo SET Elementcompo.CodeElem = Replace([ElementCompo]![CodeElem],Chr(34),Chr(45));

UPDATE ElementCompo SET Elementcompo.CodeCompo = Replace([ElementCompo]![CodeCompo],Chr(34),Chr(45));