>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


Set @mycompany = @mycompany+'%'