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%' ...

Regards
Stefan

> Regards
> Adam J.
>
>

• Next in forum: Re: how to join two text filelds in query?
• Prev in forum: how to join two text filelds in query?
• Thread view: Re: how to join two text filelds in query?

[Reply to this message]