Home » RDBMS Server » Server Administration » Re: search for '%' or '_' patterns
Re: search for '%' or '_' patterns [message #372613] Wed, 28 February 2001 04:08
ramu
Messages: 82
Registered: February 2001
Member
You can use this query to select the rows that are containing the '%' symbol anywhere of the column.

select *from
where instr(column_name,'%')>0;

Thanks..
Ramu.

Report message to a moderator

Previous Topic: Re: search for '%' or '_' patterns
Next Topic: can I read in an sql record key only?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:28:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.