Record selection with prefixes

[redbunny78]

Using Crystal 10 and Oracle

I need help with the record selection criteria for a report:

- I would like to show all tickets opened after midnight the previous day by assignment group. The opentime is a datetime field

- The assignment group needs to be limited to results with the following prefixes ( FO, ACC, Sys)

 

[CoSpringsGuy]

{opentime}=currentdate-1
and
{assignment group} in ["FO","ACC","Sys"]


unless the prefix is part of the field. If not, is there a serperator character for the prefix? Like

"FO-1234"


_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection