Home » RDBMS Server » Server Administration » WHERE clause LIKE problem
WHERE clause LIKE problem [message #370200] Mon, 08 May 2000 17:20
Messages: 44
Registered: May 2000
In a select against the "all_tab_columns" table, in the WHERE clause, I would like to use something like the following:
and TABLE_NAME like 'TMT%_S_%'
but the underscores are interpreted as wildcards of a single character. How do you convince SQL that the underscore is a literal?
Previous Topic: Re: BEST TOOL OF ORACLE
Next Topic: standard or enterprise Edition
Goto Forum:

Current Time: Sun May 26 10:22:24 CDT 2024