Subject "starting with" inside a procedure
Author

Hello! I know that there are a lot of different ways to accomplish this, but I wonder if I'm missing something...


if I want (inside a stored proc or a trigger) to know if str1 starts with str2, I can do:


   if  (position(str2 in str1) = 1) then...


but there isn't something like the "starts with" predicate we have in SQL...?


   if  (str1 starts with str2)  then...


thanks!!!


Sergio