!!!P2K_SMZONE !Functionality This database function will convert the number passed into a zoned overpunch number, which is used to interface to COBOL systems. !Parameters: |NUMBER| The number you wish to convert !Returns: Varchar2 !Errors: None !Example: {{P2K_SMZONE(~)}} !Operation The Zoned overpunch changes the least significant digit (LSD) to a character if the value is negative. In this manner, older systems can deal with positive and negative values without taking up an extra character on the interface file. If the number passed is positive, then the result will return the same number. If the value is negative, the last number will be converted according to the following table: %%center [P2K_SMZONE.JPG] %% So +34567 will return as '34567' but -34567 will return as '3456P' ---- ![Notes|Edit:Internal.P2K_SMZONE] [{InsertPage page='Internal.P2K_SMZONE' default='Click to create a new notes page'}]