How to search double quotes in fulltext search in sql?

SQL search function

• I have a database that consists of text that is translated from english into spanish and French. I have it setup so that there are 3 tables, one for each language and the text from the first record in the english table corresponds to the translatd version on the same record in the spanish and french table. Example: Record 1 on the English table has text that reads "Hi my name is John" Record 1 on the Spanish table has text that reads "Hola me llamo es Juan" Record 1 on the French table has text that reads the same thing in French.. I need to create a SQL search function that will allow the user to enter a word or phrase and search the database (English Table) to find any records containing that word or phrase and return not only the text of those records but the corresponding text from the Spanish and French tables as well.. Any Suggestions? Its probably a relatively simple search function, but I am stuck.

• Answer:

  Hi Christopher1, Thank you for the confirming that the SQL query answered your question. I will simply repeat the answer below. The query below is based on the following three table structures: Table Name: English Columns: Record_ID, English_Text Table Name: French Columns: Record_ID, French_Text Table Name: Spanish Columns: Record_ID, Spanish_Text The query will prompt you for the English text and will display the English French and Spanish for any rows that match all or part of the entered English text. SELECT English.English_Text, Spanish.Spanish_Text, French.French_Text FROM (English INNER JOIN French ON English.Record_ID = French.Record_ID) INNER JOIN Spanish ON English.Record_ID = Spanish.Record_ID WHERE (((English.English_Text) Like "*" & [English Search] & "*")); The answer was composed using personal knowledge and did not involve any online searches. Regards, lotd