On 10/06/2021 14:30, Matthias Apitz wrote:
Hello, I want to search in a VCHAR column for a string with two TAB at the end. I tried some things w/o any luck, like: select * from acq_vardata where name=concat('Test202112', 9, 9); select * from acq_vardata where name=concat('Test202112', '\t\t');
Maybe use a regular expression? https://www.postgresql.org/docs/13/functions-matching.html Ray. -- Raymond O'Donnell // Galway // Ireland ray@xxxxxxxxxxxx