I have a statement that is being used for MS Access in Delphi. However, as I need to upgrade the database to SQL, I am not sure how to reconstruct the statement. The statement that is being used for MS Access is:
SQL.Add('Select * From table1, table2 Where field1 Like ' + ' "' + Text1.text + '*' + '" ');
The statement run when a entry is entered into the text box and it will look up the SQL database and show only the refined results.
Any help is appreciated.