Update Query

[Jason K]

Hi,

I have a field that can contain two differnt variations.
Let's say the field (infoview) contains
WN1401S.C05344.MV01000.P00208 then the below logic works
fine to get 1401 out of the first node.

strFromLeftOfC = Left([infoview],InStr(1,[infoview],".")-1)
strAC = Left([infoview],2),
strNumber = Mid([infoview],3,4);

My question is, is there another query I can write to get
9222 & 1409 from below? Or can it be combined with the
above somehow?

Basically, if the letter after the first period starts
with anything but C then I need characters 2-5 if not I
need 3-6

T9222TT.P182
P1409WM.OUTL70.W1209

Thanks.

Jason