The IN_DB_UTIL_FN_GET_VERSION_BASE scalar-valued function returns the base version number for the provided schema version number. The base version does not include the schema identifiers such as ‘u’ (Unicode).
| Parameter | Description | |
|---|---|---|
| SCHEMA_VERSION | Type: | INPUT |
| Datatype: | NVARCHAR(40) | |
| Default Value: | NONE | |
| Description | Accepts the standard version number as stored in the IN_PRODUCT_MOD_HIST.PRODUCT_VERSION column. | |
| SCHEMA_BASE | Type: | RETURN |
| Datatype: | NVARCHAR(40) | |
| Default Value: | None | |
| Description |
Returns the base version of the schema number without the schema identifiers. Example of base version for 7.1.5.2u is 7.1.5.2. |
|
Examples
SELECT inuser.IN_GET_VERSION_BASE('7.1.5.2u');
DECLARE @VERSION_BASE NVARCHAR(40);
SET @VERSION_BASE = inuser.IN_GET_VERSION_BASE(inuser.IN_GET_INOW_VERSION());
PRINT 'Base Version Number '+@VERSION_BASE;