Use LIKE together with BETWEEN

Question

Navigation

#1 by (4 votes)

-2

You can select data with between along with like , for example:

public.retornotoner.observacao like between 'A%' and 'Z%'

Or is there anything that might look like this?

Data example:

Vazio Mancha branca Residuo

public.retornotoner.observacao like between 'A%' and 'S%'

postgresql

asked by anonymous 02.03.2018 / 21:03

1 answer

score 4 · Accepted Answer

4

If I understood correctly the question, this should give you the result you are looking for:

WHERE LEFT(public.retornotoner.observacao, 1) BETWEEN 'A' AND 'S'

02.03.2018 / 21:19