|
-
May 28th, 2009, 01:08 AM
#1
Thread Starter
Addicted Member
How eliminate commas in query and get particular id
Dear friends,
This is my table tblGroups
intGroupId intUserId
1 1,2,3
2 1,3
3 2,3,4
In this table i need to get intGroupId that where intUserId=2. That is "select intGroupId from tblGroups where intUserId=2."
This query is possible to get intGroupId from the above table. I need this one. What query is possible to get the id.
Hope yours reply.
Thanks
Ashok
Failing to plan is Planning to fail 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|