HI folks,

I am in need of some advice, I need to know what is the best way of forming SQL Statements.

Currently I am simply doing:

Code:
 Dim i As Integer
            strSQL = "SELECT "
            For i = 0 To Me.lstFields.SelectedIndices.Count - 1
                strSQL &= "[" & Me.lstFields.Items(Me.lstFields.SelectedIndices(i)) & "],"
            Next
            strSQL = strSQL.TrimEnd(",")
            strSQL += " FROM " & Me.lstTables.SelectedItem.ToString