Re: SQL and Regular expression

From the docs:

pattern-expression
An expression that specifies the regular expression string that is the
pattern for
the search. The expression must return a value that is a built-in character
string, graphic string, numeric, or datetime data type. If the value is not
a
UTF-16 DBCLOB, it is implicitly cast to a UTF-16 DBCLOB before searching for
the regular expression pattern. A character string with the FOR BIT DATA
attribute or a binary string is not supported.

I'm actually surprised the hex value worked....given the "FOR BIT DATA
attribute or a binary string is not supported."

Charles

On Mon, Feb 15, 2016 at 8:34 AM, <mprice@xxxxxxxxx> wrote:

I was running an SQL statement on a field in a physical file using
REGEXP_LIKE(Field1,'\xC1') expecting to find 'A' .

After this failed to return the desired results, I discovered that I have
to use the ASCII equivalent.

ie REGEXP_LIKE(Field1,'\x41')

Expected ?
or
Strange ?

Michael
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.