aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_normalize_guest_document_number
Parameters
Name
Type
Mode
i_doc_number
text
IN
Definition
SELECT NULLIF(upper(regexp_replace(btrim(i_doc_number), '[^[:alnum:]]', '', 'g')), '');