Re: Can a web based report handle a wildcard?
From: Mike <spam_at_spam.com>
Date: Mon, 2 Jun 2003 12:18:01 +0100
Message-ID: <3edb310b$0$13008$afc38c87_at_news.easynet.co.uk>
Date: Mon, 2 Jun 2003 12:18:01 +0100
Message-ID: <3edb310b$0$13008$afc38c87_at_news.easynet.co.uk>
Someone suggested this, and it solved the problem.
Use the word "wildcard" for the location parameter, and then in the SQL query add a TRANSLATE to convert it to a %
eg:
SELECT *
WHERE LOCATION = TRANSLATE(:P_LOCATION, 'wildcard', '%')
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.486 / Virus Database: 284 - Release Date: 29/05/2003Received on Mon Jun 02 2003 - 13:18:01 CEST