I have this SQL
SELECT SupplierID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, HomePage
FROM Suppliers
WHERE (Country = @Country)
... note, its not a SP
I want to display ALL rows if a user does not enter a @Country. Can someone please help me with this.
thanks