Remove whitespaces/blanks from a string

[ronnie]

Hi,

How do I remove blanhs from with a string using a select statement.

For example the tring is 'Ron nie' and I want my select to get 'Ronnie'.

Thanks