Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Select Expert Post Reply Post New Topic
Author Message
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Topic: Select Expert
    Posted: 03 Feb 2016 at 3:04am
Hi, is there a way in Select Expert to pick up only records which have particular characters somewhere in the description?

for example:

PART#        Description

001           This is a sample description

002           this is a description

003           sample description


In this case, if i wanted to pick up anything with the word "sample" in the description, regardless of where it resides within the description...is there a way to do it ? In this example, I would only want parts 001 & 003.

Thanks!

Edited by Kitty1 - 03 Feb 2016 at 3:04am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Feb 2016 at 3:12am
{table.description} LIKE "*sample*"
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 03 Feb 2016 at 3:15am
THANK YOU SO MUCH!   I WAS LEAVING OUT THE QUOTES...

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.