Search results for query: *

bborissov, that code did not work exactly, but it did make me realize that I could place the % inside the formula for the same outcome, so what I did is this: where userrole like {fn concat( '%', replace( right('&ACC&', len('&ACC&') - 1), '&', 'SUP%')) } Thank you.

I put ACCSUP in there as a temporary literal string in place of a db field for this forum.

It does, but I need to use the formula in the query to remove the first character, and the replace the '&' that is after the ACC and replace it with 'SUP' I just wanted to display what my point was with the query.

What I'm trying to do is find any record where it's like "%ACCSUP%

I am trying to use a like comparison with wildcards and I can't seem to get anything to work. My query: select USERID as email from RADplus_users where userrole like replace( right('&ACC&', len('&ACC&') - 1), '&', 'SUP ') I want to put wildcards around the "replace( right('&ACC&'...

I thought there would be some type of linking solution, but running totals worked.

I am using Crystal XI on Cache DB. I am trying to make finance reports that sum the original cost of service, as well as the payments. My problem is that I am linking: service_table s (where the original record is) left join charge_table c (where the claims are made, and MAY have charges to...