Basically I have this nullable column which I wanted to filter my resultset from. Let's take the authors table of the pubs database as an example. SELECT * FROM authors where au_fname = ISNULL(@firstname, au_fname) Seeing the query this way, I thought...