sql server programming: CONDITIONAL 'WHERE' -- sql server programming

CONDITIONAL 'WHERE'

Aleks
8/13/2005 11:40:13 PM

sql server programming: THIS IS MY QUERY:

SELECT *
FROM users a
WHERE a.usertype = 'contact' AND ISNULL (a.FirstNm,'') LIKE 'MMColParam5%'
and ISNULL (a.LastNm,'') LIKE 'MMColParam6%'

AND STATUS IN (MMCOLPARAM7)

ORDER BY d.Attorney

-------

THE LINE WHERE IT SAYS "AND STATUS IN (MMCOLPARM7), I WANT TO MAKE THAT
CONDITIONAL AND ONLY RUN IT IF MMCOLPARAM7 IS NOT NULL, IF IT IS NULL TO
SKIP THAT "AND" AND JUST EXECUTE THE REST OF THE QUERY.

HOW CAN THIS BE DONE ?

THANKS FOR THE HELP GUYS.

A

RE: CONDITIONAL 'WHERE'

John Bell
8/14/2005 2:20:01 AM

Hi

Try something like:

SELECT *
FROM users a
WHERE a.usertype = 'contact' AND ISNULL (a.FirstNm,'') LIKE 'MMColParam5%'
AND ISNULL (a.LastNm,'') LIKE 'MMColParam6%'
AND ( STATUS IN (MMCOLPARAM7)
OR MMCOLPARAM7 IS NULL )

John

[quoted text, click to view]

RE: CONDITIONAL 'WHERE'

ZULFIQAR SYED
8/14/2005 12:36:01 PM

With regards to

[quoted text, click to view]

See if this works for status filtering

AND STATUS =coalesce(MMCOLPARAM7,STATUS)

HTH..
--
http://zulfiqar.typepad.com
BSEE, MCP

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.