Or you could try the REPLACE function and have null as your replacement string.