Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: bigalligator
- Content: Threads
- Order by date
-
Need help with wildcards in WHERE clause
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&'...- bigalligator
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
Summing on one-to-many tables
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...- bigalligator
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
