Hi,

I am a newbie to informix.I need to migrate some informix procedures to SQL server.As i am new to this,I cant figure out what does the following statement do..is it some kind of string manipulation...

define sp_man_type char(1) ;
define sp_in_man_id char(8);
let sp_man_type = sp_in_man_id [ 1 , 1 ] ;

if someone could explain it ,that would be of great help.

Thanks in advance

let is used when you are going to calculate something.

ex: let a = b+ c
in this case a gets the sum of b and c...

in your case, the first parameter gets the first character of the second parameter.

Oh my God!!!

You are migrating to SQL server and I am helping you????