Like predicate
When you specify a Like predicate in the expression editor, you choose a column, an operator, and a value. You then specify whether values are included or excluded by the comparison.
The expression editor when you have selected the Like predicate is as follows. The fields it contains are:
- Column. Choose the column on which you are
filtering from the drop-down list. You can specify one of the following
in identifying a column:
- Job parameter. A dialog box appears offering you a choice of available job parameters. This allows you to specify the value to be used in the query at run time (the stage you are using the SQL builder from must allow job parameters for this to appear).
- Expression. An expression editor dialog box appears, allowing you to specify an expression that represents the value to be used in the query.
- Data flow variable. A dialog box appears offering you a choice of available data flow variables (the stage you are using the SQL builder from must support data flow variables for this to appear)
- Column. You can directly select a column from one of the tables in the table selection canvas.
- Like/Not Like. Choose LIKE or NOT LIKE from the drop-down list to specify whether you are including or excluding a value in your comparison.
- Like Operator. Choose the type of Like or
Not Like comparison you want to perform from the drop-down list. Available
operators are:
- Match Exactly. Your query will ask for an exact match to the value you specify.
- Starts With. Your query will match rows that start with the value you specify.
- Ends With. Your query will match rows that end with the value you specify.
- Contains. Your query will match rows that contain the value you specify anywhere within them.
- Like Value. Specify the value that your LIKE predicate will attempt to match.