Database lazarus / 16-Databases ---------------------------------------------------------------------- amedeo · 2020-11-23 10:41 Hy people my be this is a stupid question but I d'nt find a answer    : how to write a SQL string to find all the records of a table containing a sub-string in a field? Thanks amedeo ---------------------------------------------------------------------- dseligo · 2020-11-23 11:10 Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i select *from mytablewhere myfield like '%search_string%' ---------------------------------------------------------------------- amedeo · 2020-11-23 11:26 Great, a lot of thanks Amedeo