Check null sql server 2005

I have been writing CASE statements for a while. Subscribe to SQLTeam. Home Weblogs Forums. Posted - : I want to basically check null and then empty or zero, for columns fname and lname, age thanks. Replace isempty TableA. Viewed 92k times. Improve this question. OMG Ponies k 75 75 gold badges silver badges bronze badges. Add a comment. Active Oldest Votes. Improve this answer. Joel Coehoorn Joel Coehoorn k gold badges silver badges bronze badges.

All answers are correct, but I'll explain why So this works Fredou Fredou Raj More Raj More The value that you are substituting must be of the same data type as the field that may contain the NULL value.

Editor's Picks. The best programming languages to learn in Check for Log4j vulnerabilities with this simple-to-use script. TasksBoard is the kanban interface for Google Tasks you've been waiting for. Paging Zefram Cochrane: Humans have figured out how to make a warp bubble. Show Comments. Hide Comments. My Profile Log out. Join Discussion. Code Crawler Code Crawler 43 5 5 bronze badges. This would be the first port of call but if you are doing things like concatenating from multiple columns in a table for example, then this would exclude the row rather than just display a blank for that column — Coops.

Paul Roub Hicham Hicham 31 1 1 bronze badge. Vedran Vedran 9, 4 4 gold badges 45 45 silver badges 57 57 bronze badges. This caters for spaces as well. ChrisM 6 6 silver badges 16 16 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.

Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Visit chat. Linked Related Hot Network Questions. Question feed.