I want to write an access query to count the characters in an ntext field in a linked SQL server table.

In SQL server, I would just use this command (which wont work in access): 

```
 select datalength(nTextFieldName) //this command works on sql server but not in access 

```

In access, I can only find the len command, which wont work on ntext fields: 

```
select len(nTextFieldName) // access says nText is not a valid argument to this function.

```

Googling around, I've found a bunch of posts saying to use len, which is giving me an error.

What is the command?