Need to get the rows which having spaces.

vijayakumar.yellala · New User Joined: 19 Apr 2006 Posts: 63 Location: Chennai

Hi my requirement is I need to get the rows form table which are having the value is spaces.

this is my query:

SELECT SLS_PRSN_SSN
FROM RDR_HS
WHERE SLS_PRSN_FRST_NM = ' '
AND SLS_PRSN_LST_NM = ' '

it will work..

Regards
Vjay

dbzTHEdinosauer · Posted: Thu Sep 16, 2010 1:51 pm

Anuj Dhawan · Posted: Thu Sep 16, 2010 3:22 pm

Okay is there any question here? And did you mean"NULL", the term SPACES sounds little odd in DB2 part of the Forum.

dbzTHEdinosauer · Posted: Thu Sep 16, 2010 4:14 pm

there is no such thing as a value of NULL.

not only did the TS say: value of spaces
but the sql literal is a space.