Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with SQL-select
Maybe there is padding in the column....
I.e "select PERSID from T_TABLE where PERS_NAME =
'Smith '"
May work..
Or Try Something like..
SELECT PERSID from T_TABLE where RTRIM(PERS_NAME,' ')='Smith'"
If this works there is padding!
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 03:28:47 CST