title: Search for a certain name followed by any number (or no number)
body: <p>I want to search for a field matching a name followed by a number of variable size (including no number), but I can't see how to use the wildcards on PATINDEX and LIKE to detect an unknown number of digits.</p>
  
  <p>This is the regexp I would like to check : MYNAME[1-9]*</p>
  
  <p>It has to recognize MYNAME, MYNAME5, MYNAME12, MYNAME275, ...</p>
  
  <p>It shouldn't recognize ANOTHERNAME, MYNAMEXX12, MYNAME12X5, MYNAME12X</p>
  
  <p>PATINDEX and LIKE don't recognize the * on the regexp to indicate a variable number of digits.</p>
  
  <p>Do you know of a way to search for a pattern where a part has a variable size ?.</p>
  
  <p>Thank you.</p>