Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Impromtu query - using wildcards

Status
Not open for further replies.
jennilein

jennilein

Technical User
Mar 17, 2003
63
US
Does anyone know how to query using wildcards in Impromtu? For examply, I have a text string "1234567890" and want only those like "????5?????". I've tried using * and # as place holders, but none work.

Any tips?
 
Sort by date Sort by votes
I believe this is dependent on your database.

I know for Oracle it's "%5%".

I am what I am based on the decisions I have made.

DoubleD [bigcheeks]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Komoshon
  • Locked
  • Question
Cognos admin console query service status
Replies
0
Views
234
Komoshon
Komoshon
damzi
  • Locked
  • Question
using 2 measures as one measure in cognos transformer
Replies
0
Views
95
damzi
damzi
kvenkata
  • Locked
  • Question
Forcing subquery in main query filter as optional even when data exists
Replies
0
Views
109
kvenkata
kvenkata
vignesvar
  • Locked
  • Question
List table report is not display when run the report using cognos connection?
Replies
0
Views
80
vignesvar
vignesvar
bicon05
  • Locked
  • Question
implement SSO using Active Directory Federation Service in cognos
Replies
0
Views
101
bicon05
bicon05

Part and Inventory Search

Sponsor

Back
Top