What is alternative function in sql REGEXP_COUNT in SQL Server

Question

Below is the variable in Oracle I need to convert in SQL Server please suggest.

V_BAD_EMAIL_CNT NUMBER :=  REGEXP_COUNT(pv_bad_emails,',') + 1;

SQL Server doesn't support regex, so we would need to see exactly what pattern you are trying to count here. — Tim Biegeleisen, Feb 10 '22 at 07:55

score 1 · Answer 1 · edited Feb 10 '22 at 08:20

1

This will return the number of comma's in the string + 1 in SQL

 declare @pv_bad_emails varchar(1000);
 set @pv_bad_emails = 'a,b,c,d';
 select len(@pv_bad_emails) - len(replace(@pv_bad_emails, ',', '')) + 1

For more reference

edited Feb 10 '22 at 08:20

Dale K

answered Feb 10 '22 at 08:09

SV_

1 Answers1