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?

Report message to a moderator

Previous Topic: Re: BEST TOOL OF ORACLE
Next Topic: standard or enterprise Edition
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 05:07:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.