select REPLACE('NES 123_4_5', ' ', '')
Result - NES123_4_5