If Statement

[dtester_(Guest)]

I am using the R&R for SQL. I have the latest version of R&R and using SQL 2005.____When I do an if statement like IIF(CATCODE = "*2008), true statement, false statement). (I am using a wildcard to say any catalog code that ends in 2008) I do not get any results. If I do a statement that says IIF(CATCODE = "SD2008", etc) I get results. I assume SQL does not like the equal sign. I know in my filters I had to go to using "LIKE".____Is there another way to do the iff statements?____Thank you,__David Tester

[kfleming]

You can use the like function____IIF(LIKE("_08",CATCODE),...____will be true when CATCODE ends in 2008____Kathleen__R&R Support

[Online Payday Loans]

Kathleen that worked great. We are converting over from MOM dbase to MOM SQL. So we are converting all of our reports. One more question if I may. I run a report using dates where I compare this year to last year. My if statement is "IIF(IT_SDATE>={10/01/2006} AND IT_SDATE<=Date_rr-365,ITEMS.GROSS,0)"____My problem is with this portion, IT_SDATE<=Date_rr-365. It does not like the date-rr-365. If i put in a specific date such as {12/31/2007} works great, if I just put in date_rr it works great. ____My goal is to run a report that figures sales for a time period this year and figure the sales for the same time last year - that is why i use the date_rr-365 is to figure today^s date last year. I have tried a calculation filed called LYToday and put in the calculation Date_rr-365 and that did not work either.____Any ideas__