>The same result with LEN( client.name). The only advantage is that LEN() function doesn't depend on SET COMPATIBLE.

That is simplier.

So, I can use TYPE('alias.field') to determine the type. If it is character, I can then use LEN(). Now, the only problem is to solve the decimal lenght of numeric field.