What is the syntax for numeric wildcards in a LIKE statement? I know in SQL the syntax would be
LIKE '[0-9][0-9][0-9]'
But I cannot find anything in the documentation with this information.
numeric wildcard
+1Hi ,
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');
name
1
aaa1#2
There are more examples at this link in the Vertica Offical docs
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
