View Single Post
  #2 (permalink)  
Old July 11th, 2004, 11:15 AM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

What is the datatype of the COLUMN with which you are using CHARINDEX?

I think you are using TEXT datatype on a column that is used in your WHERE clause or in ORDER by Clause. It is better you post the structure and datatype of the entire table and also the SELECT statement that you are using, which results in ERROR.

Cheers!

_________________________
- Vijay G
Strive for Perfection
Reply With Quote