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!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: calis2
  • Content: Threads
  • Order by date
  1. calis2

    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...

Part and Inventory Search

Back
Top