I'm new to sql and have achieved simple table upates before but with this one I keep running into trouble. Please ignore the data format it is accurate, just the syntax hang up for whatever reason.All variotions of wrapping the data come up with 'near "-": syntax error', I am using SQLiteSpy to modify the database in question.Any advice very welcome.UPDATE EventTable SET Date='D.+19110402..+00000000..' , SortDate='6705438749380050956' WHERE Date='D.+19110000..+00000000..' AND EventType='18';