Problem with Startswith function

[UnleashThePain]

Hi,

I am having difficulties with the following formula:

If {?Report} startswith 'DAG' and {SKU.SUSR8} = 'Y' then '1'
I receive the error "A string is required here."

It does'nt work. The original formula is:
If {?Report} = 'DAG' and {SKU.SUSR8} = 'Y' then '1'

That formula works out well, but I would like to make the selection showing the records starting with DAG. I also tryed the several other formula's which did'nt worked out well:

If {?Report} like 'DAG%' and {SKU.SUSR8} = 'Y' then '1'

I receive the error "A string is required here."

Can anyone help, it would be appreciated.

Rob



-----------------------------------------
>>>Fornicate Under Command of the King<<<

 

[DataDivaJill]

How about
if (mid(uppercase{?report},1,3)="DAG"

is the ?report field a parmater field or a real field in your database?
usualy fields that begin with ? are parm field. so I don't see what it is matching with in your database.
Jill

 

[lbass]

Where is your cursor when you get the error message? This doesn't look like a record selection formula.

-LB