Wild card input queries

[Rovent]

I was wondering if anyone has been able to pull off a certain query, something like this:

I can get SMS to prompt for a value, and return specific matches

WHERE prod.ProductName= ##PRM:SMS_G_System_SoftwareProduct.ProductName##

And I can set up the search for anything with, let’s say, the word Oracle in the result

WHERE prod.ProductName like “%oracle%”

But has anyone figured out a way to search for anything that has the user-input in it? Something like :

WHERE prod.ProductName like “%##PRM:SMS_G_System_SoftwareProduct.ProductName##%”

(the above errors out, saying it can’t search for “%”oracle”%”)

Whenever I use the ##PRM##, it invariably looks for a specific match, so I have to enter something like “Oracle Information Navigator for Windows” for the input to get the results. I’d like to just type “Oracle” and get the same thing.

thanks!

- Alex

 

[RodTrent]

Here's the list of applicable wildcards:

http://www.myitforum.com/articles/1/view.asp?id=1096

Rod Trent
Microsoft.MVP.SMS
=======================================
Main site:

http://www.myITforum.com

=======================================

 

[mrben1]

I am trying to to the same as Rovent, but I do not think that you have answered his question.

Basically, I have a query that prompts, and i can search using wildcards ie %ba%, but I need it to add the "%" automatically either side of the search string, so by entering ba into the prompt, the query will look for %ba%.

Many Thanks,

Ben