I would like to run a SQL script (not preferable and not recommended, I know!) that removes all shipping addresses with "Box" in Line2. But I don't understand the AddressType in cls_Address. It is a Guid and different for all addresses? I can't find any relation to another table either.
How can I find out which addresses are shipment addresses?
Found out how it works. The table mcmd_SelectedEnumValue is the key.
To get all shipping addresses with Box in Line2 this is your code:
select * from cls_Address c
inner join mcmd_SelectedEnumValue s on s.[Key] = c.AddressType and s.Id = 2
where Line2 like '%box%'
Also described here:https://world.episerver.com/forum/developer-forum/Episerver-Commerce/Thread-Container/2014/2/Customer-Billing-Address-in-SQL-Query/