SQL Server Data types and operators clarification needed I would like to confirm the following with respect to the basic SQL Queries:


The float and real data types cannot be used with the equals and not equals operator in sql. If so then what else operators can i use for these data types.
Filtering based on the BLOB and XML columns is not allowed. So shall we disable any search based on these datatypes, also is there any other data type that cannot be filtered from the sql query?


[edit]
3. Also what kind of operators can i use for the timestamp data type.
Untrue. You can use them but the "approximate" nature means they could be unreliable. Use range queries (BETWEEN etc) or use decimal
If you use the max types (text, image etc are deprecated) then you can CAST or SUBSTRING etc as needed to search and filter
For XML you can search using XQuery
Note: a binary BLOB that is a word document or such can not be searched in SQL Server
Never tried any. timestamp (deprecated, use rowversion) isn't designed to be manipulatedUnless you mean datetime which as datetime functions