SELECT (LEN(Taskcode) - LEN(REPLACE(Taskcode, '.', ''))) FROM Tasks

>
>I want to you the query in SQL server, It seems the Occurs function does not exist in it.
>
>Can you please if you don't mind convert it to sql server query.
>
>Thank you very much.