Hi All,
I have set of strings in the db2 table and two range keys to search. I have to finds strings the table which would be in between the range of keys defined.
Strings in the colum to search (COLUMN_TO_SEAR CH) :
KAVICEH&,KAVICE H>,K$VICEH&,KAV ICEH$
Range of keys defined : KAVIC$$$ , KAVIC$$/
SQL query may looks like :
...
I have set of strings in the db2 table and two range keys to search. I have to finds strings the table which would be in between the range of keys defined.
Strings in the colum to search (COLUMN_TO_SEAR CH) :
KAVICEH&,KAVICE H>,K$VICEH&,KAV ICEH$
Range of keys defined : KAVIC$$$ , KAVIC$$/
SQL query may looks like :