SCALAR LENGTH VALUE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using ODBC to fetch a Row from MS ACCESS 2002 Database table that has a Variable Length column. All I need to have returned is the Width (LENGTH) of the column.

I use this type of Select

Select LENGTH(VARDATA) from TABLE....

I get a message back saying:

[Microsoft][ODBC Microsoft Access Driver] Undefined function 'LENGTH' in expression.

Anyone know how to get the length of a VARBINARY column back without returning all the data frm the column.
 
Are you looking for Len(VARDATA)?

--
Duane Hookom
MS Access MVP


mjl said:
I am using ODBC to fetch a Row from MS ACCESS 2002 Database table that has
Click to expand...
a Variable Length column. All I need to have returned is the Width (LENGTH)
of the column.
I use this type of Select

Select LENGTH(VARDATA) from TABLE....

I get a message back saying:

[Microsoft][ODBC Microsoft Access Driver] Undefined function 'LENGTH' in expression.

Anyone know how to get the length of a VARBINARY column back without
Click to expand...
returning all the data frm the column.
 
Back
Top