![]() |
If you use SUBSTITUTE to convert strings to numbers or vice versa, all values in data must be converted. That is, every value in data must appear in from_table. Otherwise, the resulting row contains ???.
|
Creates a new column named TEMP, which contains the values 7, 5, 10 (the value 1 is replaced with 7).
|
Creates a new column named TEMP, which contains the values 0 and 1 (the string "blue" is replaced with 0 and "red" is replaced with 1).
|
Creates a new column named TEMP containing the values of column V1, where any values found in column V2 are replaced with the value in the corresponding row of column V3.
|
Creates two new columns named TEMP and VX, each with values from columns V1 and V2 respectively, where any values found in column V4 are replaced with the value in the corresponding row of column V5.
|
Creates two new columns named TEMP and VX, each with values from rows 10-20 of columns V1 and V2 respectively, where any values found in column V4 are replaced with the value in the corresponding row of column V5.
|
Copyright IBM Corporation 2013. All Rights Reserved.
|