Using LIKE together with BETWEEN

Asked

Viewed 84 times

-2

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

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

Or is there something that might be similar to that?

Data example:

Vazio Mancha branca Residuo

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

postgresql

  • Look, from what I understand, you can solve this with a simple like 'A%S' or as you want...

1 answer

4


If I understand the question correctly, it must give the result you seek:

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

See working on Sqlfiddle

Browser other questions tagged postgresql

You are not signed in. Login or sign up in order to post.