Hope this is the correct group to post this message.
I have a problem using the LIKE command in a SQL command to find part of a
string in a string field. Using LIKE with a defined string containing the
whole of the string to look for works OK but cannot get it to find part of
string, as shown below. I cannot find any info in the Delphi Help or
manuals for this command but have used it in Visual Basic OK.
If the asterisks (which I believe are the wildcard characters) are removed
VS180 is found OK but not with them. I need to be able to enter a partial
string and locate the whole.
procedure TformManuals.Button1Click(Sender: TObject);
var tofind : string;
tofind := '"*VS180*"';
Query1.SQL.Add('SELECT * FROM MANUALS');
Query1.SQL.Add('WHERE Model LIKE' + tofind +'');
Thanks in advance,