I have the following query
select SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName
where SMS_R_System.LastLogonUserName like ##PRM:SMS_R_System.LastLogonUserName##
It asks for a username and returns the PC name associated with it. My question is how do I modify the query to place wild characters ahead and behind the inputted text?
Example: Right now I have to know the exact user name or enter %portionofusername%
It is my desire to place the % wildcard characters concantenated to the input so that I only have to know a small portion of the username.
- Edited by NathanKimball Tuesday, November 27, 2012 8:57 PM