Wildcard Set???

I've looked around for a wildcard for a single character to be used within a LiveReport. A DBA told me "?", but that fails. I want to include something that contains: "F&E" and he suggested "lower (a.subwork_title) like 'f?e%%'" and this doesn't work. I tried a single "%" and that doesn' either. What is the set of WildCards that are used within LiveReports (with an Oracle DB)?

Find more posts tagged with

Comments

Lee_Butler_(lbutler_(Delete)_2946657)

Message from Lee Butler <lbutler@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hi,

Try this: lower (a.subwork_title) like '%%' || 'f&e' || '%%'.

It should pull instances of 'f&e', case insensitive, from anywhere within a string.

Cheers,
Lee.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 05 March 2004 21:39
To: eLink Recipient
Subject: Wildcard Set???

Wildcard Set??? Posted by MCIWOR02User1 (Schmidt, Colin J) on 03/05/2004 04:38 PM

I've looked around for a wildcard for a single character to be used within a LiveReport. A DBA told me "?", but that fails. I want to include something that contains: "F&E" and he suggested "lower (a.subwork_title) like 'f?e%%'" and this doesn't work. I tried a single "%" and that doesn' either. What is the set of WildCards that are used within LiveReports (with an Oracle DB)?