Can we use POSITION function in stored procedure ?
It gave error when I try to use this function , probably because Stored Procedure itself contains POSITION keyword !!
Actually I wanted to see if particular character is present in the string and need to follow few steps depending on the criteria..
My mistake , there was some issue the way I was using in
SQL ( Select POSITION('' in fieldname) into variable from table )
and as part of SPL Code ( IF position('',variable) = 0 THEN )
I corrected and its working both ways .. Thanks for the response