Just posting some solution that you can think of doensot make you pro and doesnot make ignorant.

When someone posts on forum it means that they can't get through documentation(which you...

Oh, if I only know that its a number and dont know the size, how do I do it?

Very confusing for me. Cant find proper documentation.

I just tested that and I think problem is with the [0-9].

• Row1: akahdkahsd PQ5|1|896^^^^^^^tester
• Row2: akahdkahsd PQ5|1|456^^^^^^^tester
• Row3: akahdkahsd PQ5|1|895^^^^tester
• Row4: akahdkahsd PQ5|1|8965^^^^^^^tester
• Row5: akahdkahsd PQ5|1|54^^^RTH67^^^^tester

Like clause is "%PQ5|1|896^^^^%"...

But isn't ^ wild character for like and regular expression.

Hi, column value I provided has more content to left and right of the string I have provided. So, can't use charindex. Need to use regex. regex doesnot identify ^^^^....