Windows PowerShell Programming, Scripting, Error Handling, and Debugging - Professional SQL Server 2008 Administration with Windows PowerShell - page 51

Comparison Operator Description

Tests for equality

-eq

Tests for inequality

-ne

Tests whether the value on the left is greater than the value on the right

-gt

Tests whether the value on the left is greater than or equal to the value on
the right

-ge

Tests whether the value on the left is less than the value on the right

-lt

Tests whether the value on the left is less than or equal to the value on the
right

-le

Tests, using wildcards, whether two values match. The wildcard(s) go on
the right side.

-like

Tests, using wildcards, whether two values fail to match. The wildcard(s)
go on the right side.

-notlike

Tests, using regular expressions, whether two values match. The regular
expression goes on the right side.

-match

Tests, using regular expressions, whether two values fail to match. The
regular expression goes on the right side.

-notmatch

-ceq Tests for case-sensitive equality

-cne Tests for case-sensitive inequality

-cgt Tests whether the value on the left is greater than the value on the right.

Case-sensitive comparison.

-cge Tests whether the value on the left is greater than or equal to the value on

the right. Case-sensitive comparison.

-clt Tests whether the value on the left is less than the value on the right.

Case-sensitive comparison.

-cle Tests whether the value on the left is less than or equal to the value on the

right. Case-sensitive comparison.

-clike Tests, using wildcards, whether two values match. The wildcard(s) go on

the right side. Case-sensitive comparison.

-cnotlike Tests, using wildcards, whether two values fail to match. The wildcard(s)

go on the right side. Case-sensitive comparison.

-cmatch Tests, using regular expressions, whether two values match. The regular

expression goes on the right side. Case-sensitive matching.

-cnotmatch Tests, using regular expressions, whether two values fail to match. The

regular expression goes on the right side. Case-sensitive matching.

-ieq Tests for case-insensitive equality

Continued