Implicit conversion from data type ntext to varchar is not allowed

[damipera]

Hi guys,

I am trying to run a query and I am having this ADO error in SQL server2000:

"implicit conversion from data type ntext to varchar is not allowed. use convert function to run this query"

The query runs when the field, "testfieldcolumn" is set as varchar but when I set this as ntext it gives me the error above.

Any ideas?

Thnx

 

[mrdenny]

You can post the query that you are running?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[RyanEK]

Hi,

Use convert as suggested...

select convert(varchar(8000),testfieldcolumn) as testfieldcolumn

Ryan