Home » SQL & PL/SQL » SQL & PL/SQL » %
% [message #246315] Wed, 20 June 2007 10:36 Go to next message
ninja17
Messages: 12
Registered: June 2007
Junior Member
Hi, I need to find some names in the table, that contains this character: %

I cannot use something like this :
select Name from Table1 where Name LIKE '%%%';

Pls how can I solve this problem, thanks
Re: % [message #246316 is a reply to message #246315] Wed, 20 June 2007 10:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LIKE '%\%%' escape '\'

Regards
Michel
Re: % [message #246503 is a reply to message #246316] Thu, 21 June 2007 02:53 Go to previous message
ninja17
Messages: 12
Registered: June 2007
Junior Member
cool

thank you
Previous Topic: Custom field type in Oracle
Next Topic: Row to column conversion
Goto Forum:
  


Current Time: Tue Dec 06 06:30:45 CST 2016

Total time taken to generate the page: 0.11235 seconds