How do I use specify zero or more repeating groups in a T-SQL LIKE clause

42 Views Asked by At

I'm trying to pattern match something using LIKE. The below isn't my actual problem, but say I want one or more repetitions of a group of characters, for instance digits or comma (may be different groups of characters).

Matching a single digit or comma would be '[0-9,]', but what if I want to match against one or more repetitions?

I've tried '[0-9,]' and '[0-9,]*', but * matches a single wildcard. Effectively my question is how do I repeat a sequence in LIKE?

0

There are 0 best solutions below