outside of asp i can run this query ok---

Select * from TMSCUST where ID = '5'

(in the sql table - sql server 2000 - ID is type int...)

but when i try to run it in my asp page, i get this error:

Syntax error converting the varchar value '5, ' to a column of data type int.

i think it might be a quotation mark issue?, but cant figure out anything that works......

asp statement:
strSQLu = "UPDATE TMSCUST SET billtofirstname = 'strFirstname', billtolastname = 'strLastname', source = 'strSource', billtostate = 'strState' " & _
"WHERE ID = '" & intID & "' "

"WHERE ID = " & CInt(intID)

that got it.....thanks much!

Yes in ASP this doesn't work for a number field because of the unneeded single quotes:
Select * from TMSCUST where ID = '5'

But this would work:
Select * from TMSCUST where ID = 5