Hi eily,
quote:
i want to know is it possible when using a parameter in a stored proc that when i go to execute the proc that instead of entering the values one by one that i could enter "ALL" and get all possible values returned
something like
SELECT * FROM table WHERE field LIKE '%'
where % can be % or any number?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]