REGEX

General
General covers Articles, Reference documentation, FAQs, Downloads and Blogs that do not belong to a specific subject area. General-purpose Articles about everything and anything
Enthusiast

REGEX

Hi,

Is it mandatory to use single quotes for search string as mentioned in below example.—>> '[^0-9]*'

SELECT REGEXP_REPLACE ('ABCD123-$567xy','[^0-9]*','',1,0,'i');

Thanks
1 REPLY
Teradata Employee

Re: REGEX

The single quotes don't have anything to do with being a REGEX search string. They are required simply because in your example this is a character string literal.