Can we use position function in stored procedure

Database

Can we use position function in stored procedure

Hi ..

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..

Thanks

2 REPLIES
N/A

Re: Can we use position function in stored procedure

Of course you can.

Is it part of the SPL code or within a SQL?

Could you show what you did so far?

Dieter

Re: Can we use position function in stored procedure

Dieter ,

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