[RESOLVED] .csv file select statement problem

[billboy]

This is similiar to the other problem I have posted , althought I think I have narrowed this one down a bit more.

It seems that if I use this statement and some of my Street Full Address fields do not have a "-" then I get an error, "Provider could not determine the string value"

If I remove the Left and InStr then I am good to go

So I examined one of my database files and discovered that in one of them there were some records of address with no postal code "-" ,I deleted them and it works

Dim comm As New OleDb.OleDbCommand("Select *, Left(([Street Full Address]), InStr([Street Full Address],'-')-1)  as StreetFullAddress From " & Me.OpenFileDialog1.SafeFileName & " Where Status  <> 'S'", con)
        Dim dalist As New OleDbDataAdapter(comm)

In summary I think what I need is to account for there maybe being records that dont have the "-" in the address?