select regexp_replace('asdfhsdf&&1&&asdfasdf&&2&&asdf','&&[0-100]&&','') output
here it replaces first pattern but not the 2nd pattern
o/p
output
asdfhsdfasdfasdf&&2&&asdf
even if we use position its not working something like both wont work
select regexp_replace('asdfhsdf&&1&&asdfasdf&&2&&asdf','&&[0-100]&&','',2) output
select regexp_replace('asdfhsdf&&1&&asdfasdf&&2&&asdf','&&[0-100]&&','',15) output