How to convert '(1,2,3,4)' to '(1),(2),(3),(4)' in VB.net

Question

User-582711651 posted

Hi friends, 

I would like to pass string values '(1),(2),(3),(4)'  from '(1,2,3,4)' to SP SQL,

how to do this? 

Thanks in advance

Answer 1

User753101303 posted

Hi,

You want to use that with IN ? Use "1,2,3,4" and  https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-2017

If you have an older version you'll find tons of script emulating this function. Or do you use some other db ?

Answer 2

User-582711651 posted

Hi <g class="gr_ gr_17 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="17" data-gr-id="17">PatriceSC</g>, 

Noted, but I need this for the different purpose, pls refer my previous post URL: How to get one more same row SQL, you also responded that post, IN is not works.

and I am using SQL 2008 version

Thanks in advance. 

Answer 3

User839733648 posted

Hi ayyappan.CNN,

I've seen that you've already found the soution by yourself in your previous post https://forums.asp.net/t/2151336.aspx?How+to+get+one+more+same+row+SQL 

I just add this comment to tell those people who may meet the same problem.

Best Regards,

Jenifer