Questions regarding lenght() function

[Thorsten Hohage]

Hi,

what is wrong with this query

	select idserial, length(descriptiontext) from cb_group order by  
length(descriptiontext) desc

I got a
	12:45:13: Error: line 1:1: unexpected token: (

but this is really sql92 now, nothing especially IMHO.


Furthermore  this one

	select max(length(descriptiontext)) from cb_group

obviously produce a wrong result with returning 9, but this first row  
has a length of 13 and there must be some much longer text inside.

Btw. descriptiontext is defined as Text, any ideas / comments?


regards

Thorsten Hohage
--
objectmanufactur.com - Hamburg,Germany