When coding a LIKE condition ( in Oracle ), is it possible to search for a keyword that is followed by one character in a defined pattern list ? eg.
so that the column must obviously contain the value 'keyword' but also be followed directly by the character 'a', 'b', or 'c' ?
I want to be able to do this in one statement instead of
LIKE '%keyworda%' OR
LIKE '%keywordb%' OR
Is this possible ? I dont really want to do it using in INSTR, search for the position of keyword and see what the next character is, because if
'keyword' exists twice it will not pick up the second occurance...
well what i should have mentioned before is, that my pattern of characters on the end would never exist in my keyword ( eg. keyword is a table_name, pattern-list would be punctuation [;, ], and those characters will never exist in a table_name...
so it was achieved by :
WHERE TRANSALTE(column_name, '; ', ',,') LIKE '%keyword,%'
so just converting all of the list of pattern characters to the one... but i didnt really mention that before with the pattern-list not even belonging in the keyword did i ?
does that earn me 50c AU instead of the full dollar ?