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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Contains 1

Status
Not open for further replies.
rewob65

rewob65

Technical User
Nov 13, 2004
110
GB
Hi

I am trying to use the select expert to chose data that contains the word "docket" somewhere in the field. I assume i use the instr command but cannot make it work.

Many thanks
 
Sort by date Sort by votes
No need for Instr()

Try

{yourfield} like '*docket*'

or if docket can be manually entered and could have mixed case

uppercase({yourfield}) like '*DOCKET*'

Ian
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
287
mmck1964
mmck1964
Kevin Mizzi
  • Locked
  • Question
Crystal reports Description contains bracket
Replies
11
Views
205
Kevin Mizzi
Kevin Mizzi
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
195
SarahSCPDAdmin
SarahSCPDAdmin
socalvelo
  • Locked
  • Question
Date Range Formula - Data from two months ago only
Replies
4
Views
213
pmax9999
pmax9999
GCL2007
  • Locked
  • Question
Exporting Data Only with Subreport Extra Row
Replies
0
Views
39
GCL2007
GCL2007

Part and Inventory Search

Sponsor

Back
Top