Update Query Syntax

[señorbadger]

Hi i got a slight sql problem i get a runtime error

Syntax error in UPDATE statement

any ideas??

thanks all

[Memnoch1207]

what is the datatype for the SCRNAME field?...to allow it to have the accent mark above the "n" in "Senorbedger" the datatype should be nvarchar.

Here would be my assumptions based on the field names.

1) Any field that ends with ID (UserID) would be an int datatype and not accept strings, it would accept only numbers. The field would be better suited as Username = 'sam', rather than UserID = 'sam'.

2) Level would be an int type also, therefore you wouldn't need (') marks around the number 2....(') marks are only for strings, not numbers.

3) Same for field name ID...shouldn't be '1', it should be 1