Replace statment

[jagrok]

Thank you working perfect.

What do you means, come from ?

This Uniq ID is imported from xls form, and might be replaced by main ID of company which is 26200321 GREEN PL a.b.c.

uniq_id; name_of_company


37500152 White Video ltd
26600328 Brown Serwis Sp. z o.o.
26800130 White Goods GmbH
26900597 Yellow Partner-Service
26101704 RED,a.b.c.
26300126 ORANGE a.b.c.
26500315 Black Bobby - company Bobby
26200321 GREEN PL a.b.c.
26300412 GREEN PL a.b.c. like - partner
26400275 GREEN PL a.b.c.- Berlin 3
26100276 GREEN PL a.b.c.- Berlin 4
26201020 GREEN PL a.b.c.- Berlin 8
26400052 Purple mountain center

And i think it could be

If ID is 26300412;26400275;26400276;26201020 then replace with 26200321

[June7]

Do you want to replace the actual original raw data with these calculated values? Or just do the calcs in query:

SELECT *, IIf([name_of_company] LIKE "GREEN PL a.b.c.*", Left([name_of_company],15), [name_of_company]) AS NewName, IIf([name_of_company] LIKE "GREEN PL a.b.c.*", 26200321, uniq_id) AS NewID FROM GFW;