CONTAINS NUMBER

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Parameters 4 Output 5 Example 6 Source Code

Syntax

   APPLIB.CONTAINS_NUMBER ( string )

Purpose

Returns true if the string contains at least one numeric character, returns false if it does not contain a numeric character, and returns null if string is null.

Parameters

• string [VARCHAR(65535)]: The string to check for numbers.

Output

• [BOOLEAN] true if string contains at least one numeric character, false if it doesn't and null if input is null

Example

A reference table provides the data for the following example(s).

Values( APPLIB.CONTAINS_NUMBER('A7P'), APPLIB.CONTAINS_NUMBER('AP') )

Returns:

CONTAINS_NUMBER('A7P') CONTAINS_NUMBER('AP') true false

Source Code

http://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/string/ContainsNumberUdf.java