Search code examples
sqladvantage-database-server

How to get the length of the contents of a varbinary field with SQL in Advantage Database Server db?


Does anyone know if it is possible to get the length of the contents of a varbinary field using SQL with Advantage Database Server V11?

Regards


Solution

  • The obvious function to look for would be LENGTH(field) or LEN(field) (see online help).

    If those only work on character fields, then you can always cast.