The SUBSTITUTE function doesn't return the correct result when text
For example, I expect the following to produce an empty result:
Instead it produces the string
- 16 Oct 2007
yes this has also annoyed me
And there is similar problem with REPLACE which cannot return a number 0 or an empty string either even though there can be good use for both in applications.
- 06 Jan 2009