1.
UPDATE [Leader].[dbo].[INVMB]
SET [MB017]='MA101'
WHERE SUBSTRING([MB001],1,2)='01'
2.
UPDATE [Leader].[dbo].[INVMB]
SET [MB017]='MA102'
WHERE SUBSTRING([MB001],1,2)='02'
3.
UPDATE [Leader].[dbo].[INVMB]
SET [MB017]='MA201'
WHERE SUBSTRING([MB001],1,2)='03'
4.
UPDATE [FLUXTEK_1].[dbo].[INVMB]
SET [MB017]='MA401'
WHERE SUBSTRING([MB001],1,2)='31'
5.
UPDATE [FLUXTEK_1].[dbo].[INVMB]
SET [MB017]='MA301'
WHERE SUBSTRING([MB001],1,2) BETWEEN '04' AND '30'
6.
UPDATE [FLUXTEK_1].[dbo].[INVMB]
SET [MB017]='MA301'
WHERE SUBSTRING([MB001],1,2) BETWEEN '32' AND '44'