Reply to Re: how to join two text filelds in query?
Posted by Stefan Rybacki on 10/13/52 11:24
Adam J. wrote:
> Hello
>
> I need to make a query like
>
> .... WHERE name+surname LIKE '%search%'......
> but what is a syntax of this (name+surname does not work)
>
Use CONCAT.
.... WHERE CONCAT(name,surname) LIKE '%search%' ...