🚀 go-pugleaf

If you are looking for the hello string, use %.

'hello%'   -   if it starts with hello
'%hello'   -   if it ends with hello
'%hello%'   -   if it has with hello

--
Christopher F. Neumann

"Failure is not an option!"

Karen Elmquist <kelmquis@wisdomwareNOSPAM.com> wrote in message
6sjidu$eq98@forums.borland.com...
>when I execute an update or insert SQL statement and there is a '?' in a
>string value, I get exceptions.
>
>for example:
>
>Query1.SQL.Add('Update table set description = :value1 where number =
>:value2');
>Query1.Params[0].AsString := 'hello?';
>Query1.Params[1].AsInteger := 1;
>Query1.ExecSql;
>
>      ---  boom!!