rozendaa@xs4all

You could try the following (untested) console application [CODE] Imports System.IO Imports System Module Module1 Sub Main() Dim stw As New StreamWriter("c:\WDriveReplaced.txt", False) Dim str As New StreamReader("c\WDrive.txt") While (Not str.EndOfStream) stw.WriteLine(Path.GetFileName(str.ReadLine())) End While stw.Flush() stw.close() str.close() End Sub End Module [/CODE]

try putting single quotes (') around both SESS_MEMBER_ID instances in the query.

If you are want to compare the content of the two files, you could use the following [CODE] using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.IO; namespace ConsoleApplication2 { class Program { static void Main(string[] args) { // here must be code to check the number and types …

Yes, it is possible, but you should show what you have tried till now, before you can expect an how-to-do-this answer.

Assuming you distribute your application to multiple machines where you want to use the default instance of Sql Server, here is a copy of the code I use in a program that has the same requirements (allthough the parameters in the connectionstring are different. Crucial is the stament with csb.DataSource) …