classic asp SQL string syntax error

[splendid9]

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'.

this is the line.......
strSql = strSql & "AND customer = '" & Session("Accoun t") & "'"


could anyone help me out with this ............?

[DrBunchman]

Can you print the rest of your sql statement or at least the few lines before and after this one.

Ta

Dr B

[Shouper]

Try sticking a space between " and AND

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'.

this is the line.......
strSql = strSql & "AND customer = '" & Session("Accoun t") & "'"


could anyone help me out with this ............?