I would like to know if someone would know how to write a Stored Procedure (using Select statement) to search on a partial word, for instance, like "micro", for Microsoft Office, Microsoft Communicator, etc. or an ordered number of characters, that are unique, like "obe", and will retrieve, ad"obe" or adobe.
I'm using SQL 2005 and I'm running the search against a DB called platform_validation_tool and the table's name is dbo.software.
The important column names that I want to retrieve this data on are Name(which would be the simple name like Microsoft Office Communicator) and software_package(which would be a Tivoli package name from the registry stored in this column with the name like "Microsoft_Office_Communicator_2005_XP2K_I8^1.0.0.0.5).
I know you can use the clause WHERE NAME LIKE '%microsoft%' would retrieve all microsoft software packages. I'll assume you would have to setup parameters and concatenate them or something like that.
Has or would anyone know how to accomplish this task
Sincerely,
Wallace