• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Transact-SQL > Criteria with WHERE

Criteria with WHERE

You can use the WHERE clause to filter the required data. The options available are similar to those provided for Access queries with slightly different syntax. There are certain differences, especially for the specification of date and time, character strings, and placeholders, as described in the following sections.

Comparison Operators

You can use the comparison operators described in Table 9-14.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint