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..
Of course you can.
Is it part of the SPL code or within a SQL?
Could you show what you did so far?
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