Home » Developer & Programmer » Reports & Discoverer » Set Condition to Filter on Special Character
Set Condition to Filter on Special Character [message #161868] Tue, 07 March 2006 10:12 Go to next message
ddavid
Messages: 6
Registered: September 2005
Location: Austin, TX
Junior Member
I need to search a data field for records containing the character "%" but since this character is a wildcard character, it returns all records instead. Does anyone know how to search for this special character in Discoverer???

"Last_name like '%'" - returns all last names instead of names containing the character %.


All assistance appreciated.

ddavid

Report message to a moderator

Re: Set Condition to Filter on Special Character [message #161869 is a reply to message #161868] Tue, 07 March 2006 10:16 Go to previous messageGo to next message
benoitchabot
Messages: 15
Registered: October 2005
Location: Quebec , Canada
Junior Member
You could try

replace(Last_name, '%', '?') like '?'

Report message to a moderator

icon6.gif  Re: Set Condition to Filter on Special Character [message #161870 is a reply to message #161869] Tue, 07 March 2006 10:38 Go to previous message
ddavid
Messages: 6
Registered: September 2005
Location: Austin, TX
Junior Member
That worked. Much appreciated.

ddavid

Report message to a moderator

Previous Topic: print barcode using third party tool
Next Topic: Whether Report printed or not
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 15:51:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.