469,097 Members | 1,602 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

strings with sql

3
I have the following peace of code
"where table.field in ('field1', 'field2') ")

i need to make a string that i can put into my in statement how do i build a correct string to use inside the sql statement
Nov 18 '06 #1
1 1375
willakawill
1,646 1GB
I have the following peace of code
"where table.field in ('field1', 'field2') ")

i need to make a string that i can put into my in statement how do i build a correct string to use inside the sql statement
Hi. I am assuming that you mean to use this statement in VB.
Expand|Select|Wrap|Line Numbers
  1. "WHERE table.field IN ('" _
  2. & strYourStringHere & "','" _
  3. & strYourNextStringHere _
  4. & "')"
  5.  
Nov 19 '06 #2

Post your reply

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

Similar topics

20 posts views Thread by Ravi | last post: by
17 posts views Thread by Gordon Airport | last post: by
16 posts views Thread by Paul Prescod | last post: by
4 posts views Thread by agent349 | last post: by
25 posts views Thread by Rainmaker | last post: by
6 posts views Thread by Broeisi | last post: by
19 posts views Thread by pkirk25 | last post: by
95 posts views Thread by hstagni | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.