Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-26 : 23:14:07
|
Eric writes "this query:
select customer_name, len(customer_name)
from event_orders
where event_date>'2/13/01'
produces this error (via ASP):
[Microsoft][ODBC SQL Server Driver][SQL Server]'len' is not a recognized built-in function name.
The error is the same - len is not a function, but the presentation is different no matter which way I try to get at it, from ASP, MSQuery, ISQL/W. Using len, LEN, or Len makes no difference.
I am running SQL Server 6.5 on WinNT 4 SP 5
field "customer_name" is type char, length 80, nulls allowed
Is there really no len() function in SQL Server 6.5? It's shown on microsoft's support site as a valid T-SQL function (doesn't say version info), it's also in some articles on this site. Could I possibly have disabled the function with security or any other means? This same user logon can select, update, insert into and delete.
thank you - any help would be appreciated" |
|
|
|
|
|
len function not available?