#DateForumTypeThreadPost
507 Aug 2014 @ 07:52 PDTDatabaseReplyWhy did the numeric value search in the varchar field fail; and a date format display questionthank you so much!
406 Aug 2014 @ 03:51 PDTDatabaseReplyWhy did the numeric value search in the varchar field fail; and a date format display question NEW_TXT Char2HexInt(NEW_TXT) 6 360000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000...
306 Aug 2014 @ 02:07 PDTDatabaseReplyWhy did the numeric value search in the varchar field fail; and a date format display questiontrim(new_txt) did not work either. Only substr(new_txt,1,1) works in this case. And I tried CHAR2HEXINT(new_txt). No special character is revealed there. Only one digit number in the field. Weird.
206 Aug 2014 @ 10:36 PDTDatabaseReplyWhy did the numeric value search in the varchar field fail; and a date format display questionThank you for responding. BTW, I meant to say "new_txt is a varchar(20) field", not "memo_code". Thanks again.
105 Aug 2014 @ 11:35 PDTDatabaseTopicWhy did the numeric value search in the varchar field fail; and a date format display questionCan someone tell me the reason why the following is not working - select count(*) from table1 where memo_code='STATUS' and new_txt='1'; but the following works - select count(...