-----------------------------------------------------------------------------
-----	CLI																-----
-----		Ne contient pas de prospects								-----
-----------------------------------------------------------------------------

SELECT CLI.DOS, CLI.TIERS, CLI.NOM, CLIENT.NOM, CLI.CPOSTAL, CLI.REPR_0001, CLI.VIL, CLIENT.VIL 
FROM CARTOFLEX.dbo.CLI CLI, CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLIENT 
WHERE CLIENT.TIERS = CLI.TIERS AND CLI.DOS=1 AND (CLI.USERCRDH BETWEEN '2023-01-01 00:00:01' AND '2023-03-01 23:30:00');



SELECT CLI.TIERS, CLI.NOM, CLI.REPR_0001
FROM CARTOFLEX.dbo.CLI CLI
WHERE (CLI.TIERS Like 'C%') AND (CLI.NOM Like 'E%')



SELECT CLI.TIERS, CLI.NOM, CLI.REPR_0001
FROM CARTOFLEX.dbo.CLI CLI
WHERE (CLI.TIERS Like 'C%') AND (CLI.NOM Like 'DELTA%')


SELECT CLI.TIERS, CLI.NOM, CLI.REPR_0001, CLI.EMAIL 
FROM CARTOFLEX.dbo.CLI CLI
WHERE (CLI.TIERS Like 'C0011473')

UPDATE CARTOFLEX.dbo.CLI SET CARTOFLEX.dbo.CLI.EMAIL = 'contact@myec2m.com' WHERE CARTOFLEX.dbo.CLI.CLI_ID = 8572 AND CARTOFLEX.dbo.CLI.TIERS = 'C0011473'

SELECT CLI.CLI_ID, CLI.TIERS, CLI.NOM, CLI.REPR_0001, CLI.EMAIL FROM CARTOFLEX.dbo.CLI CLI WHERE CLI.CLI_ID = 8572 AND CLI.TIERS = 'C0011473'