Thanks!

You are right!, my mistake was take all as an only string.

Although it is strange that SQL Server does not accept $()

because I tried it on Powershell and it works...

Hi

It was solved with other option

Instead of using *_$($NumberOfWeek)_*

I created three variables more

$Open="*_"

$Close="_*"

$PartialName=$Open+$NumberOfWeek+$Close

and it replaced that piece of statement

If someone has other solution using $(...), it would be great