Home » RDBMS Server » Server Administration » Re: search for '%' or '_' patterns
Re: search for '%' or '_' patterns [message #372598] Mon, 26 February 2001 23:54
priya
Messages: 108
Registered: February 2000
Senior Member
Vinay,

Replace the % or _ with any char of your preference when querying and chk the results. Eg:

SQL> select * from dept where replace(dname, '%', 'PER') like '%PER%';

DEPNO DNAME LOCATION
--------- ------------------------------ ------------------------------
30 abc%def CALIFORNIA
30 %AUDIT CALIFORNIA

Regards,

Priya

Report message to a moderator

Previous Topic: Creating a foreign key that references two other tables
Next Topic: In continuation with Date/Time subtraction
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 08:18:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.