I am trying to define a SQL Server Select statement as follows:

WHERE mydate = @mydate AND mycompany LIKE @mycompany

The results I want are all records for mydate = a given date and all company names that start with the contents of the parameter. For example, if 'MICRO' was passed, I would want to see "MICROSOFT", "MICROCORP", "MICROSCOPE", etc...

Also, if the @mycompany parameter is blank, I would want to see all companies that fall into that date range.

Can this be done?

Thanks,

Jerry