D Denis Member Nov 10, 2003 #1 Greetings! In SQL window the result of the statement select '1'||chr(0)||'2' from dual; is displayed like '1' whereas select '1'||chr(1)||'2' from dual; is displayed like '12' The recent result really misleads because anything like '*'||chr(0) looks like NULL Cheers Denis
Greetings! In SQL window the result of the statement select '1'||chr(0)||'2' from dual; is displayed like '1' whereas select '1'||chr(1)||'2' from dual; is displayed like '12' The recent result really misleads because anything like '*'||chr(0) looks like NULL Cheers Denis
Marco Kalter Administrator Staff member Nov 10, 2003 #1 Character 0 is indeed a tricky thing for many windows controls. We'll try to fix this.
