Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: recrd selection when text chunk contained in field Post Reply Post New Topic
Author Message
aaml216
Newbie
Newbie
Avatar

Joined: 02 Nov 2011
Online Status: Offline
Posts: 24
Quote aaml216 Replybullet Topic: recrd selection when text chunk contained in field
    Posted: 13 Dec 2011 at 6:13am
Hi, I hope you can help me.  I am trying to do a record selection based on a text field containing (rather than starting with) a certain chunk of text.  For example, I would like to keep any record where FIELD1 contains BC.  So I keep the line when FIELD1 is ABCDE, and don't keep when FIELD1 is FGHIJ.  I am a newbie and not familiar with SQL but am comfortable with the formula editor.  Thanks!!
Amanda from the Mid-Atlantic
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 13 Dec 2011 at 6:39am
in select expert
 
{field1} like '%BC%'
it may be '*BC*' though
 
IP IP Logged
aaml216
Newbie
Newbie
Avatar

Joined: 02 Nov 2011
Online Status: Offline
Posts: 24
Quote aaml216 Replybullet Posted: 13 Dec 2011 at 6:59am
This is perfect, thanks!
Amanda from the Mid-Atlantic
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.