UPDATE {table} SET columnN = SUBSTRING (columnN, 2, LEN(columnN));