Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by calis2
-
Using IN with an INT and varchar id list (eg: 1,4,5,6)
Thanks Terry & Tim. Tim, I had actually tried that method and sql still appeared not to like it. (thx for your help netherless :PP) However, that dynamic function is a great idea...just need to work out how to construct *dynamic sql* statements in CF. thx- calis2
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Using IN with an INT and varchar id list (eg: 1,4,5,6)
I need to be able to relate a varchar field that contains a list of id numbers (eg: 3,4,7,89,203) to a category id field (int). I've tried :: C.category_id IN (SELECT mID = CAST ( M2.member_category as INT) FROM member_details M2 WHERE M2.member_id = M.member_id) It returns this rather...- calis2
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
