Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SQL Server - TEXT datatype cannot be used in a comparison or ORDER BY, but can be used in LIKE

Jul 12 2011 10:35AM by Madhivanan   

The datatypes text, ntext, and image cannot be used in an ORDER BY Clause. Similarly they cannot be compared unless you convert them to varchar or nvarchar datatypes. However you can use LIKE operator or use the condition IS NULL like below

WHERE text_col like 'test%'
WHERE text_col IS NOT NULL
Read More..   [0 clicks]

Published under: SQL Server Tips ·  ·  ·  · 

Madhivanan
3 · 39% · 12441
8
 
4
 
5
 
0
Incorrect
 
0
Interesting
 
0
Forgotten


Submit

1  Comments  

  • All 3 (TEXT/NTEXT and IMAGE) are marked for deprecation, hence it would be a good idea to avoid using them in any new implementations.

    commented on Jun 2 2012 2:37PM
    Nakul Vachhrajani
    4 · 33% · 10587

Your Comment
Sign Up or Login to post a comment.
"SQL Server - TEXT datatype cannot be used in a comparison or ORDER BY, but can be used in LIKE" rated 5 out of 5 by 8 readers
SQL Server - TEXT datatype cannot be used in a comparison or ORDER BY, but can be used in LIKE , 5.0 out of 5 based on 8 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]