Which SA version has introduced the LEN() function?

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()?

documentation

asked 14 Feb '11, 09:41

Volker Barth
39.5k●355●539●811
accept rate: 34%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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.

-john.

permanent link

answered 14 Feb '11, 12:51

John Smirnios
11.4k●3●94●154
accept rate: 38%

@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

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

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

learn more about Markdown

Question tags:

documentation ×90

question asked: 14 Feb '11, 09:41

question was seen: 2,169 times

last updated: 14 Feb '11, 12:51

SAP SQL Anywhere

Which SA version has introduced the LEN() function?

Follow this question

Related questions