[bsathishmca]

Hi Guiders,

I need to check the whether space is there in verchar column or not.


select a.mycol1,a.mycol2 from mytable a where (decode(length(a.mycol1),length(rtrim(a.mycol1)),' No') is NULL and a.prcs_dte='11-Aug-2008';

The above query only i have used.But i need to check for n number of varchar columns in same table.Can any one suggest me.

Note : I have only select permission on the tables.So i could not able to use user_tab_col.

[r035198x]

Why not just use INSTR ?

[debasisdas]

simply try to check if

column=trim(column)

i think you are not trying to findout space inbetween chars.