RowIdToRowIdNum

In version 6.x Siebel introduced a function named RowIdToRowIdNum that converts a traditional Siebel row Id into a unique numeric value.RowIdToRowIdNum alleviates the problems pertaining to the confusion of characters 0 (zero) and O (oh), 1 (one) and l (ell), and the concerns over the rare occurrence of offensive words appearing within RowId numbers . It also eases customer entry of a row Id-based identifier in the case of automated telephone technical support.

> RowIdToRowIdNum converts the base-36 part of a Row Id to a decimal number and is guaranteed to produce unique row Id numbers. Row Ids generated by RowIdToRowIdNum will be of variable length because the base-36 (also known
as MOD 36) to base-10 conversion will require at least as many character places as the original number used, and usually more.
> For example, the base-36 row Id 12-6RX8L would translate to 12-8021253 while 12-Y09KG would become 12-57119344 through decimal conversion. Five characters in a traditional row Id could require seven (10000[36]=1679616) or eight places (ZZZZZ[36]=60466175) in decimal. Six characters in a traditional row Id could take eight (100000[36]=60466176) to ten places (ZIK0ZJ[36]=2147483647, ZZZZZZ[36]=2176782335) in decimal.
> While RowIdToRowIdNum returns a numeric value, there is still a prefix that is 1 to 3 characters in length which is separated from the body of the row Id by a hyphen or plus sign. If EIM was used, there may be a second prefix. The Corporate Prefix (CP) is in decimal format, not base-36 format.
The non-numeric characters cannot be removed. Generally, the desire to remove them is based on the business requirement to allow telephone callers access to enter the number (such as a service request number) or for printing reports. In the former case, either the * or # keys can be used for the non-numeric characters, or they can simply be ignored, however, there is a remote possibility of calling duplicate requests if the characters are ignored. For reports or other field use, the non-numeric characters can be masked out using a simple script.