Space character that persists in varchar2 in Oracle 11g for display in SSRS 2008?

In my test below, the single space was not converted to a null.

In my test below, the single space was not converted to a null: SQL> CREATE TABLE t (col VARCHAR2 (10) NOT NULL); Table created. SQL> INSERT INTO t (col) 2 VALUES (' '); 1 row created. SQL> SELECT CASE col WHEN ' ' THEN 'I am a single space' ELSE 'I am not a space' END AS col FROM t; COL ------------------- I am a single space 1 row selected.

SQL> SELECT LENGTH (col) FROM t; LENGTH(COL) ----------- 1 1 row selected. Are you trimming the values before inserting?

Yes. Look at that. I'm trimming.

Sorry about that, and thanks for the good catch. – ErikE Jan 11 at 23:56.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.