The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
numeric wildcard
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.
0
Comments
Hi ,
You have REGEXP_LIKE().
Examples of using it:
There are more examples at this link in the Vertica Offical docs
https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/SQLReferenceManual/Functions/RegularExpressions/REGEXP_LIKE.htm