Please resolve the best way to make this work...
I know the below would never work, I've tried a hlaf dozen solutions including dynamic sql, but this is just the best way to describe what I'm trying to do.
If city not passed as null then I want the query to include it in the where statement.
CREATE PROCEDURE sp_CityStateSearch
State = @State
CASE WHEN @CIty IS NOT NULL THEN
AND City = @City