space holder in prompts?

[Namh]

Hi,

I wanna use something like a space holder for a prompt textfield. For example, if the user beginns the string with an * I wanna use the operator "CONTAINS" if the user uses a * as a placeholder in his string I wanna use "STARTS WITH".

I tried it with a simple if function, but got only some strange errors.

IF (?Parameter? STARTS WITH '*')
THEN (Database.Table.Field CONTAINS ?Parameter?)
IF (?Parameter? CONTAINS '*')
THEN ((Database.Table.Field STARTS WITH '?Parameter?)
ELSE (Database.Table.Field = '?Parameter?)
END

any help would be appreciated,

Namh

 

[KingCrab]

Easy with a dropdown and he user wont have to worry about * placement.

Create a dropdown with the CONTAINS, STARTS WITH, ENDS WITH

filter:
(<param>='CONTAINS' AND <Field> LIKE '%<param2>%' ) OR (<param>='STARTS' AND <Field> LIKE '<param2>%') OR
(<param>='ENDS' AND <Field> LIKE '%<param2>')

 

[Namh]

thanks KingCrab,

problem is that I have strict guidelines... so I need the * place holder