Sunday, March 22, 2009

COALESCE With Like Sql-server

using COALESCE With Like in Sql-server
 
SELECT
 * FROM PHONEMEMO WHERE phto like '%' + COALESCE(@phto, phto)+'%'
and
 phfrom like '%' + COALESCE(@phfrom, phfrom)+'%'
 
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)