General information
Forum:
Microsoft SQL Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only