Wildcards not working using set selection formula in CRPE?

[Jacque]

When attempting to query using wildcards and using set selection formula in CRPE, we get no records returned upon printing.

This is what is passed and does not work:
LowerCase({Table.fieldnamestr1}) startswith 'b_' and ({Table.fieldnamenum1} = 1 or {Table.fieldnamenum1}) = 0) and ({Table.fieldnamedate1}) >= '2001/12/18 10:25:38')
which does not work nor does using any of the following options after the startswith function: 'b?c' or 'b%' or 'b*' or 'b?'.


When this is passed it works:
LowerCase({Table.fieldnamestr1}) startswith 'b' and ({Table.fieldnamenum1} = 1 or {Table.fieldnamenum1}) = 0) and ({Table.fieldnamedate1}) >= '2001/12/18 10:25:38')

Any suggestions would be appreciated! Thanks in advance.
Crystal Version 8.5

 

[kenhamady]

Startswith can't use wildcards, just literal characters. Use LIKE for wildcards. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[Jacque]

Thanks Ken, I appreciate your help.
Jacque