,ch03.13605 Page 139 Wednesday, November 29, 2000 4:42
,ch03.13605 Page 139 Wednesday, November 29, 2000 4:42 PM In examining the query, note that parentheses impact the order in which WHERE criteria are processed according to Operators Precedence. The database s default sort order determines how the WHERE clause retrieves results sets for a query. For example, Microsoft SQL Server is (by default) dictionary-order and case-insensitive, making no differentiation between Smith , smith , and SMITH . But Oracle uses dictionary-order and case-sensitive, finding the values Smith , smith , and SMITH to be unequal. There are more specific capabilities of the WHERE clause than what is illustrated in the example. Table 3-9 helps provide a quick summary of the common capabilities of the WHERE clause. Statements SELECT 139
Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost PHP MySQL Web Hosting services