PACKED2DECIMAL
Function Type | Predefined function | |
|---|---|---|
Syntax | PACKED2DECIMAL( <packedValue> ) | |
Description | Converts a Packed data type to a decimal value. | |
Argument | Description | |
<packedValue> | Packed value to be converted. | |
Returns | Decimal | |
Example | Where Source.Table1.Field1 is a packed field. This example converts the packed value to a decimal. (PACKED2DECIMAL(Source.Table1.Field1) | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*