Searching for parameters with text string values

You can specify parameters that have text string values. In this case, the parameter values are not converted to numeric values.

For example, in Simple mode specify this criteria:

  • Parameter = COLOR
  • Value (min) = a
  • Value (max) = z

Now, switch to Advanced mode. In a SQL Server database, the syntax is displayed as shown here.


PARAM_CODE = N’COLOR’ AND PVALUE >= N’a’ AND PVALUE <=N’z’