I need a SQL Stored Procedure to return Vendor information for a list in a form.
I created a View that returns only the columns that I need.
I created a Stored Procedure that returns the list using a Company parameter. The problem is the parameter....
The Company column is a tinyint and I cast it as varchar(3) so I could use '%' as a wildcard for the parameter. It returns the list, but does not filter like I need it to - if the parameter entered is 10, I get results for Companies 101-109 too, etc.
What is the correct/best method of including a wildcard that will return the needed result?