You can specify more than one group alias, separating the WITH…AS predicates by using commas.
When a group alias is referred to in a WHERE clause predicate, the condition is applied to each column in the group. The logical values resulting from matching each column are combined by using the OR logical operator.
You must define the alias before it can be used, and it can only be used within the WHERE clause. The alias_name must be a regular identifier preceded with a required pound sign (#).
.gif) Note: |
|---|
|
Only the FREETEXT predicate supports column grouping and aliases by using the WITH…AS predicate. The CONTAINS predicate does not support column grouping and aliasing.
|
The columns specifier can contain one or more column specifiers, separated by commas. The list of columns must be enclosed in parentheses, and each column has the following syntax:
<column_identifier> [<weight_assignment>]
The column identifier can be regular or delimited.