fulltext as a column name

[cfaulkner]

We have a vendor that decided using SQL keywords was ok for column names. I have a column named "fulltext" that I must manipulate. BOL states that you can do this but that you then must address them as quoted identifiers. I can't get anything to read this column when used in a function like LEN().

These all fail:

select top 10 len(fulltext)
from dbo.localevent (nolock)

select top 10 len([fulltext])
from dbo.localevent (nolock)

so does using set quoted identifier on and "'s

Any ideas on how to manipulate this column in a select statement?

Thanks!

 

[SQLDenis]

If the column is a text datatype then you can't use LEN

try datalength instead

These functions and statements can be used with ntext, text, or image data.

Functions Statements
DATALENGTH
READTEXT
PATINDEX
SET TEXTSIZE
SUBSTRING
UPDATETEXT
TEXTPTR
WRITETEXT
TEXTVALID


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[cfaulkner]

Thank you, this worked:

select substring([fulltext],84,datalength([fulltext]))

I need to strip the first part of this off.