Archives of the TeradataForum
Message Posted: Wed, 19 Oct 2011 @ 09:12:22 GMT
<-- Anonymously Posted: Wednesday, October 19, 2011 05:07 -->
I have a procedure named proc_test
Create proc_test(in resd_var varchar(3)) Begin Insert into table select fieldname1, Resd_var, /* this is the input variable*/ Fieldname2 From End; Call proc_test('BN')
So I checked the table I can t find same value, I found 'B N' as he is adding something between the two characters.
If I add substr:
fieldname1, Substr(Resd_var,1,2) /* this is the input variable*/ Fieldname2 From
I don t want to add substr to all my querries, I will be thankful if you have another solution.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|