#DateForumTypeThreadPost
411 Jul 2011 @ 02:45 PDTDatabaseTopicSimple UpdateI know this is pretty basic. Any help appreciated. Update Employee set end_date=(Select effective_date-1 from Employee where empid=1) where empid=1 Basically I am trying to set the end date w...
327 Aug 2010 @ 07:41 PDTDatabaseReplyHandling the EMPTY/NULL value in the select queryIt works. Thanks CarlosAL. I Appreciate.
226 Aug 2010 @ 07:29 PDTDatabaseReplyHandling the EMPTY/NULL value in the select queryTo make is simple. SELECT CASE WHEN TRIM(COL1) IS NOT NULL OR TRIM(COL1)'' THEN COL1 ELSE 0 END FROM W_TABLE WHERE DB_NAME= 'tera' In the table there is only 1 record which has the DB_N...
125 Aug 2010 @ 02:45 PDTDatabaseTopicHandling the EMPTY/NULL value in the select queryI am trying to get a 0 value returned when execute the below query if my condition is not satisfied. I tried running in SQL assistance and returned nothing for null/empty condition SELECT CASE W...