User Profile

Collapse

Profile Sidebar

Collapse
or1980
or1980
Last Activity: Nov 25 '06, 05:19 PM
Joined: Nov 18 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • or1980
    started a topic strings with sql
    in SQL Server

    strings with sql

    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
    See more | Go to post
    • or1980
      replied to In
      in SQL Server
      Hello and thank you for your help.
      I figured out in part now i have a problem with building my string
      currently i have what you suggested and its working
      my example:
      "where SOHeader.OrdNbr in ('AL000005', 'AL000006') ")

      I have an indefinite number of order numbers and i'm trying to build a string to put into my sql and i cant figure that part out. I have the building of the string inside a do...
      See more | Go to post

        Leave a comment:

      • or1980
        started a topic In
        in SQL Server

        In

        Beginner looking for help.

        I have a unlimitted amount of values that i would like to compare against a field in a database. I was told to use an "IN" stetement against a string. I cant figure out the correct syntax


        "where table.field in (field1, field2, field3) ")

        whats the correct syntax for Visual Basic?
        See more | Go to post
        No activity results to display
        Show More
        Working...