Marco Napoli wrote:
> I have a WHERE clause when the end user picks to see ALL records or a
> selected id records. I am using the below CASE Statement to try to
> accomplish this but if there are records with the contact_id = NULL
> they do not show up. My CASE statement when ALL is picked it does a
> comparision that should be true all the time, contact_id =
> contact_id. Is there a different way to accomplish this?
>
> @ALL = 'ALL'
> @contact_id = 300
>
> WHERE (CASE WHEN 'ALL' = @ALL THEN contact_id ELSE @id END) =
> contact_id
>
>
> Thank you.
> Peace in Christ
> Marco Napoli
> http://www.ourlovingmother.org

"Marco Napoli" <marco@avantitecnospam.com> wrote in message
news:O%23Y899smEHA.596@TK2MSFTNGP11.phx.gbl...
>I have a WHERE clause when the end user picks to see ALL records or a
>selected id records. I am using the below CASE Statement to try to
>accomplish this but if there are records with the contact_id = NULL they do
>not show up. My CASE statement when ALL is picked it does a comparision
>that should be true all the time, contact_id = contact_id. Is there a
>different way to accomplish this?
>
> @ALL = 'ALL'
> @contact_id = 300
>
> WHERE (CASE WHEN 'ALL' = @ALL THEN contact_id ELSE @id END) = contact_id
>
>
> Thank you.
> Peace in Christ
> Marco Napoli
> http://www.ourlovingmother.org
>
>