How to separate Comma Delimated Varchar value to int in SQL?

Question

0.00/5 (No votes)

See more:

SQL

Suppose @
@id Varchar(50)='12,1,2,5'
how to separate Each Value ?? in Sql

Posted 21-Feb-14 0:50am

k07

Add a Solution

Comments

Krunal Rohit 21-Feb-14 6:56am

You want to select the records based on this comma separated values ?
-KR

k07 24-Feb-14 4:47am

Actually this varchar value is passed as a parameter.I got this comma separated value by appending the id of checked radio button list.I want to separate each value in my query ....pls help...or suggest if there is any other method to get the checked radio list value?

Bala Selvanayagam 21-Feb-14 6:56am

If could could tell us why do you want to separate into each numbers and the intended usage then it may be helpful to suggest something

k07 24-Feb-14 4:48am

Actually this varchar value is passed as a parameter.I got this comma separated value by appending the id of checked radio button list.I want to separate each value in my query ....pls help...or suggest if there is any other method to get the checked radio list value?

Bala Selvanayagam 24-Feb-14 6:20am

Hello,

AS explained below by "OriginalGriff", if you are going to use in a sub query you do not need to separate each value.

You can get away without separating (which can slow down the query) most of the time and you need to let us know exactly what is your intended usage, if you needs a solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-02-21T00:54:00

Solution 1

Have a look at this: Using comma separated value parameter strings in SQL IN clauses[^] - it explains how to do it for use in an IN clause, but the principle is the same regardless of what you are trying to achive with the CSV string.

Posted 21-Feb-14 0:54am

OriginalGriff

Comments

k07 24-Feb-14 5:00am

Thanks for your support...

OriginalGriff 24-Feb-14 5:09am

You're welcome!