Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2004 @ 12:26:07 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Victor,

the CTI-Application is just sending the "dialed digits", so we need a logic to somehow "normalize" the input.

E.g: We get '00431313002626' or '01313002626' or ... as input, but you find the customer info only under '01313100'. This means we may cut off country codes at the beginning and extensions ( e.g. 2626 ) at the end ( also the lenght of the extensions may vary ).

This logic cannot be done in a macro - this was the reason for taking a SP.

Christian

	<Prev	Next>		<<First	<Prev	Next>	Last>>