What is the syntax for numeric wildcards in a LIKE statement? I know in SQL the syntax would be
But I cannot find anything in the documentation with this information.
You have REGEXP_LIKE().
Examples of using it:
CREATE TABLE tbl1 (name VARCHAR);insert into tbl1 values ('aaa1#2');insert into tbl1 values ('1');-- look for values with Numbers in select * from tbl1 where REGEXP_LIKE(name, '\d');name1aaa1#2
There are more examples at this link in the Vertica Offical docs