During my current tests with proxy tables, I have noticed that the MS SQL-compatible LEN() function is supported with SA 11.0.1 and 12.0.0. In contrast, older versions (e.g. 10.0.1.3722) do not accept that function.
(That came as a surprise - I had tried to use LEN()/LENGTH() to find out whether SA would rewrite such functions for different server classes...)
As there seems to be no reference to LEN() in the docs at all:
When was LEN() introduced? And is this just a short form for LENGTH()?
asked 14 Feb '11, 09:41
It was introduced in 11.0.0 GA and is exactly an alias for LENGTH(). Looking at the history, I'd say it didn't manage to get documented because it was added by/for the IQ team. I don't know if the intention was to include it in SA or if it should have been conditionally compiled only for IQ as it was in 9.x. Do you like having it? I don't see any good reason to remove it now that it is out there in the wild.
answered 14 Feb '11, 12:51