How to paste extracted phone number in sql query with dynamic variable to execute?

[vnsatyasunil]

For eg,phonenumber1=+14123456789
phone number2=+14987654321,+14333555777

In sql query,it should be passed like this if one phone number exist
‘+14123456789’
It should be passed like this if double phone numbers are there
‘+14987654321’,‘+14333555777’
Please help anyone

[Yoichi]

Hi,

How about the following expression?

"'"+String.Join("','",yourString.Split(","c))+"'"

Regards,

[vnsatyasunil]

@Yoichi

"'"+String.Join("','",yourString.Split(","c))+"'"

If I use this expression, getting output like this
‘{+14567098765’,‘+14890987890’

[Yoichi]

Hi,

Can you check your input string? In my environment, it works as the following.

Regards,

[vnsatyasunil]

Thanks.It worked