|
Archives of the TeradataForumMessage Posted: Wed, 19 Oct 2011 @ 09:12:22 GMT
<-- Anonymously Posted: Wednesday, October 19, 2011 05:07 --> Dear All 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. Thank you.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||