Stored Procedure With Array parameters

Question

I have phone in my arrays such

 string phones="05763671278,05763271578,04763125578"

How can I result of all phone in that array?(for this case there must be return 3 records)

SELECT * FROM Accounst where Phone in ('05763671278,05763271578,04763125578')

but it return null although this phone in table

use a splitter from this site and inner join to the result set is one way, assuming your "array" is a comma separated parameter you are passing in. — S3S
– S3S, Commented Jun 20, 2017 at 20:24

benjamin moskovits · Accepted Answer · 2017-06-20 20:24:40Z

1

if phone is a string (varchar or char) you want:

Phone in ('05763671278','05763271578','04763125578')

answered Jun 20, 2017 at 20:24

5,5441 gold badge14 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TheEsnSiavashi · Accepted Answer · 2017-06-20 20:29:15Z

0

You are missing the quotations. Do it like this:

SELECT * FROM Accounst where Phone in ('05763671278','05763271578','04763125578')

It returns NULL because it looks for a phone number as:

'05763671278,05763271578,04763125578'

and obviously this is not a phone number.

answered Jun 20, 2017 at 20:29

TheEsnSiavashi

1,2551 gold badge15 silver badges31 bronze badges

this give error Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '

Wow... duplicate answer for the win. Original.