hi
i am working on one query in interbase.
i am new to interbase and i am not getting the prad function used in that query.
please help me to get this function 'prad'.
the query is like
select a.hier_desc, b.hier_desc, b.hier_num, from hierprime a,hiermast b,customermaster c
where( ((a.hier_num) = (b.hier_num)) and (prad(c.cust_hier_code,(prad(b.hier_num,2,1)-1)*4+1,4) = (b.hier_num || b.hier_code)) and (c.customercode='115164' ) );
please send me information about prad function in interbase.
Thanking you
Rajkiran.🙂
