Assuming that (@mycompany is varchar w/o trailing spaces

WHERE mydate = @mydate AND mycompany LIKE (@mycompany + '%')

>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.
>