You can use COALESCE function to handle NULL.
For example SELECT COALESCE(col,'UNKNOWN') FROM tbl WHERE....
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
No comments:
Post a Comment