How to convert this SQL Server

kumaran22 · July 30, 2019, 4:49pm

Hello,
What does SQL Server use for instr and regexp_substr. How would i convert the following piece of code in SQL Server.

INSTR(REGEXP_SUBSTR (URI, '/([[:alnum:]]+(/|?){3}){1,2}'),'/',1,3) > 0

Thanks.

harishgg1 · July 30, 2019, 4:57pm

Hope this helps

++++++++++++++++++++

robert_volk · July 31, 2019, 1:03am

SQL Server does not have built-in regular expression matching or replacement. You could add such support via SQLCLR.

There are code examples online, but make sure to review the code carefully before adding it to your database.