I have the following string of text
2PB 3A 2PB GER USBCP HDMI 1MLP WWW
I am looking for the best way of counting how many time
[1-9]P occurs in the string.
I have tried using variations of
LEN(a1.description)-LEN(REPLACE(a1.description, PATINDEX('[1-9]P%',Text), '')) which gets me close, but there are some descrepancies.