Hi all
I was wondering if there was a way to get a portion of a string based on a
separator character. What I needed to do was want to bring out a part of the
version number.
1.23.456.789
I want to get just the third portion, 456. So I could query on strings that
have a version number with
Please try :
SET TERM !! ;
alter PROCEDURE SP_VERSION_NOS(
PORTION smallint,
SEPARATOR char,
EARLIER_TO integer)
RETURNS (
VERSION_NO varchar(80)
)
AS
declare variable i smallint;
declare variable SEPARATOR_POS Integer;
declare variable VERSION_PORTION varchar(80);
declare
Please check this :
SET TERM ^ ;
ALTER PROCEDURE SP_VERSION_NOS (
PORTION smallint,
SEPARATOR char(1),
VERSION_UPTO varchar(80) )
RETURNS (
VERSION_NO varchar(80) )
AS
declare variable i smallint;
declare variable SEPARATOR_POS Integer;
declare variable VERSION_UPTO_PORTION_INT
