The text, ntext, and image data > types cannot be compared or sorted, except when using IS NULL or LIKE > operator

by

since you are using SQL Server, why not change the data type to VARCHAR(100)?

To work around this error without changing the datatype, the TEXT or NTEXT column needs to be converted to VARCHAR or NVARCHAR when used in either the ORDER BY clause or the GROUP BY clause of a SELECT statement. eg, which is alittle bit messy

SELECT  CAST(email AS NVARCHAR(100)) email, 
        COUNT(CAST(email AS NVARCHAR(100))) AS NumOccurrences
FROM    Booking
GROUP   BY CAST(email AS NVARCHAR(100))
HAVING  COUNT(CAST(email AS NVARCHAR(100))) > 1

More Related Contents:

  1. Case statement for multiple columns
  2. SQL where clause odd behavior [closed]
  3. SQL Server Exec issue [closed]
  4. Count(*) vs Count(1) – SQL Server
  5. How do I escape a single quote in SQL Server?
  6. NOT IN vs NOT EXISTS
  7. Simple way to transpose columns and rows in SQL?
  8. Only inserting a row if it’s not already there
  9. Unpivot with column name
  10. Selecting data from two different servers in SQL Server
  11. Is a view faster than a simple query?
  12. How to convert DateTime to VarChar
  13. Most efficient way in SQL Server to get date from date+time?
  14. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  15. SQL performance on LEFT OUTER JOIN vs NOT EXISTS
  16. Stored Procedure with optional “WHERE” parameters
  17. SQL Server: Howto get foreign key reference from information_schema?
  18. SCOPE_IDENTITY() for GUIDs?
  19. How do I perform a GROUP BY on an aliased column in SQL Server?
  20. How do you import a large MS SQL .sql file?
  21. Difference between Subquery and Correlated Subquery
  22. How to execute .sql file using powershell?
  23. How to write UPDATE SQL with Table alias in SQL Server 2008?
  24. Restrict an SQL Server connection to a specific IP address
  25. Getting Dates between a range of dates
  26. Using tuples in SQL “IN” clause
  27. Can SQL Server Express LocalDB be connected to remotely?
  28. Cumulative Total in MS Sql server [duplicate]
  29. What does ON [PRIMARY] mean?
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment