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. 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

Volker%20Barth's gravatar image

Volker Barth
accept rate: 32%

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.


permanent link

answered 14 Feb '11, 12:51

John%20Smirnios's gravatar image

John Smirnios
accept rate: 39%

@John: Thanks for the explanation! - As stated, LEN() is compatible with MS SQL, and that's practical for proxy tables. So I don't think it should get removed. But a slight documentation note would be fine. - For SA-only development, I personally will continue to use LENGTH().

(14 Feb '11, 14:02) Volker Barth

LEN comes in handy for people who also code in PowerScript (PowerBuilder) where LEN is a built-in-function

(14 Feb '11, 14:33) Reimer Pods

I would leave it as it is. Just document it :).

(14 Feb '11, 19:48) Dmitri
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 14 Feb '11, 09:41

question was seen: 1,377 times

last updated: 14 Feb '11, 12:51