Help with WHERE Clause in Stored Procedure

[paulmac106]

Hi,

I have an sp with the following WHERE clause

@myqarep varchar(50)

SELECT tblCase.qarep FROM dbo.tblCase

WHERE dbo.tblCase.qarep = CASE @myqarep WHEN '<All>' THEN
dbo.tblCase.qarep ELSE @myqarep

@myqarep is returned from a combo box (ms access)...the user either
picks a qarep from the combo box or they leave the default which is
'<All>'

they problem i'm having is that if the record's value for
dbo.tblCase.qarep is null...the record does not show up in the
results...but i need it to

any help is appreciated.

thanks
Paul

[David Portas]

... WHERE qarep = @myqarep
OR @myqarep = '<All>'

--
David Portas
SQL Server MVP
--

[paulmac106]

thanks for the quick response...i'll give it a try!

David Portas wrote:

... WHERE qarep = @myqarep
OR @myqarep = '<All>'

--
David Portas
SQL Server MVP
--