Home » RDBMS Server » Server Administration » WHERE clause LIKE problem
WHERE clause LIKE problem [message #370200] Mon, 08 May 2000 17:20
Richard
Messages: 44
Registered: May 2000
Member
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: Fri Oct 30 03:35:23 CDT 2020