Gowdra Gadhla
Friday, August 20, 2010
SQL query "when Null" will not work
SQL query Null will not work for the below case
select case amount when null then 0 else amount end from [Table]
Change this as below, this will work
select case when Amount is null then 0 else amount end from [Table]
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment