>Hi everybody,
>
>I have a form, where the user can make selection criteria. On this form I have a button, which says: "Show criteria".
>If I have this kind of criterion, for example, PRICE<=5000000, I'm thinking about presenting it as PRICE<=$5,000,000. My question is: how can I perform such string modifications? As you understand, I return each criterion as a string lcCrit, so it might be "between(price, 100,1000000)" for another example.
>
>Thanks in advance.

I suppose you have several controls to capture the criteria, just use the values in those to construct a new string with the formatted value, in the same way you build the string to execute the SQL.

Just an idea.