Re: SQL and Regular expression

[Charles Wilt <charles.wilt@xxxxxxxxx>]

> 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.