Hello, I have a field in a table which is of type ntext.
I need to check how many characters are in this field to make sure that the import has pulled in all the data I expected it to.
When I try to create a query looking for the length of the field I get an error message. Could someone please give me the correct syntax.
In MS Access I would have said:
SELECT Len([qText]) AS Expr1
Could you give me the equivalent for sql server 2012.