Remove whitespaces/blanks from a string

[ronnie]

Thanks Jurij,

I want to remove all the occurences of whitespaces after a comma.

This is what i get with the above query

1* SELECT REPLACE('Tom, Hanks' , ',&nbsp ', ',') FROM dual
SQL> /

REPLACE('TOM,&nbsp&nbsp&nbsp&nbspHANKS',',',',')
---------------------------------
Tom,&nbsp&nbsp&nbsp&nbspHanks


It should be

Tom,Hanks


Thanks