>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
like @mycompany+'%'
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
