Subject | "starting with" inside a procedure |
---|---|
Author | |
Post date | 2018-07-24T16:13Z |
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