469,887 Members | 1,855 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,887 developers. It's quick & easy.

spliting string values in stored procedure

Hi I Pass The 3 String Value Like "1,2,3" 2nd String "x,y,z"
3rd String "a,b,c"

Spilit The Those String Values And Compare The Value"1" Into Table
The Table Contain Data Only One Column,remaining Column Or Empty.if This 1 Is Match With Table The Corresponding Values Are Update Into Table
Jul 13 '07 #1
1 1578
srinit
43
Hi I Pass The 3 String Value Like "1,2,3" 2nd String "x,y,z"
3rd String "a,b,c"

Spilit The Those String Values And Compare The Value"1" Into Table
The Table Contain Data Only One Column,remaining Column Or Empty.if This 1 Is Match With Table The Corresponding Values Are Update Into Table
hi
Can you tell me your requirement clearly.
Use charindex and substring
Jul 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

18 posts views Thread by Steve Litvack | last post: by
9 posts views Thread by nsj | last post: by
15 posts views Thread by cj | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.