These are the statements that are currently giving me the problems. SELECT @main_id:=ID, @FCSecID:=FCSecID, @Periodicity:=Periodicity, @EOP:=EOP FROM main_data_temp WHERE checked=0 ORDER BY fcsecid ASC LIMIT 1; SELECT * FROM actuals WHERE [EMAIL PROTECTED] AND Period LIKE '[EMAIL PROTECTED]'; # AND EOP LIKE '[EMAIL PROTECTED]' ORDER BY n8 ASC; The first statement works exactly as it should returning 1 row of data that has not been checked, but the second statement does not return any data when it really should be. If I chop off the statement to be only "SELECT * FROM actuals WHERE [EMAIL PROTECTED]" then it works just fine returning data but as soon as I add any LIKE clause into the statement nothing is returned. Am I missing something easy here or is this just not possible? Bobby
