System Center Configuration Manager TechCenter >
System Center Configuration Manager Forums
>
Configuration Manager Software Distribution
>
SCCM 2007: How do I limit a wilcard to alpha characters
SCCM 2007: How do I limit a wilcard to alpha characters
- I am trying to create a collection using queries and rules in SCCM 2007. I have it so it works almost but I want to specify that the wildcard % in the name must be a letter not a number ie.... System Resource.Name is like "KRHSLT%" this gives me all systems named krhslt... followed by anything, I Only want KRHSLT followed by letters not numbers or letters and numbers. I have tried "KRHSLT(a-z)%" but it returns no results. Can someone please help with this! Thanks!
Answers
Check out this link that describes SQL wildcards: http://www.w3schools.com/sql/sql_wildcards.asp.
Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys- Marked As Answer byEric C. MattoonMSFT, ModeratorFriday, November 06, 2009 9:34 PM
- Proposed As Answer byReddy Surendar Friday, November 06, 2009 6:01 PM
All Replies
Check out this link that describes SQL wildcards: http://www.w3schools.com/sql/sql_wildcards.asp.
Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys- Marked As Answer byEric C. MattoonMSFT, ModeratorFriday, November 06, 2009 9:34 PM
- Proposed As Answer byReddy Surendar Friday, November 06, 2009 6:01 PM
- Perfect! That helped me figured out what I was missing :-) Thanks!
