Hi everyone,

I have the following query

select SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName

from  SMS_R_System

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.

Thanks!!!

• Edited by NathanKimball Tuesday, November 27, 2012 8:57 PM

Nope, that doesn't work either. That actually takes away the functionality of the wildcards.

Well I tried it again this morning and it work fine.