LIKE pattern T-SQL

Question

I have wrote a phraser which is phrasing a quite long string into small pieces, after the phrasing of one item is completed, it removes him from @input and continue, until it wont be able to find any items to phrase. I am selecting items based on LIKE pattern.

In some cases, there are however it is selecting some other parts of the message, and then it's end in infinitive loop.

The pattern I am looking for to be selected using LIKE clause is in format of :

(Any number from 1 to 9) + (variable length A-Z only) + '/' + (variable length A-Z only)+space of Cr or Lf or CrLf.

--This is what I do have: 
DECLARE @match NVarChar(100)
    SET @match  =  '%[1-9][a-z]%'

DECLARE @input1 varchar(max),@input2 varchar(max)  
    SET @input1 ='1ABCD/EFGH *W/17001588 *RHELLO SMVML1C'

DECLARE @position Int 
    SET @position = PATINDEX(@match, @input1);

SELECT @position;

--after the loop- it is also 'catching' the 1C at the end of the string: 

SET @input2     = '*W/17001588 *RHELLO SMVML1C'
SET @position   = PATINDEX(@match, @input2);

SELECT @position

---In order to eliminate this, I have tried to change @match:

SET @match  =  '%[1-9][a-z][/][a-z]%'

SET @position = PATINDEX(@match, @input1);
SELECT @position  --postion is  0, so the first item, that should have been selected, wasn't selected
SET @position   = PATINDEX(@match, @input2);
SELECT @position --postion is  0

Many thanks for help!

Answer 1

Try changing your match variable/criteria to this:

SET @match  =  '%[1-9][a-z]%[/][a-z]%'

This will get you the desired result. Loosely translated it is saying "Get me the starting position of the first match where the pattern is [anything]-[number from 1-9]-[single letter from a-z]-[anything]-[slash]-[single letter from a-z]-[anything].
Hope this helps!