Hi,
I need to update the columns below using the 2 byte postcodes below where they match the original DB postcode but will need a wildcard as I matching a 2byte postcode against a full postcode.
sorry I now its pretty basic but appreciate yur help! 
-- Postcode regions
ALTER TABLE [Matching]..[Cafod catholic] ADD [x_Sout_East] varchar (50) NULL;
ALTER TABLE [Matching]..[Cafod catholic] ADD [x_North_East] varchar (50) NULL;
ALTER TABLE [Matching]..[Cafod catholic] ADD [x_North_West] varchar (50) NULL;
ALTER TABLE [Matching]..[Cafod catholic] ADD [x_East_Midlands] varchar (50) NULL;
ALTER TABLE [Matching]..[Cafod catholic] ADD [x_West_Midlands] varchar (50) NULL;
ALTER TABLE [Matching]..[Cafod catholic] ADD [x_South_West] varchar (50) NULL;
ALTER TABLE [Matching]..[Cafod catholic] ADD [x_N_Ireland] varchar (50) NULL;
ALTER TABLE [Matching]..[Cafod catholic] ADD [x_Scotland] varchar (50) NULL;
ALTER TABLE [Matching]..[Cafod catholic] ADD [x_Wales] varchar (50) NULL;
postcodes
SOUTH EAST
al,bn,cm,ct,gu,hp,lu,me,mk,ox,po,rg,rh,sg,sl,so,ss,tn
GREATER LONDON
br,cr,da,e,ec,en,en,ha,ig,kt,n,nw,rm,se,sm,sw,tw,ub,w,wc,wd
NORTH EAST
Dh,dl,hg,hu,ls,ne,sr,ts,wf,yo
NORTH WEST
Bb,bd,bl,ca,ch,cw,fy,hd,hx,l,la,m,ol,pr,sk,wa,wn
EAST MIDLANDS
Cb,co,de,dn,ip,le,ln,ng,nr,pe,s