hi i am trying to update my table with a single update query
update students set studentID ='001093' where studentID ='1578093'
but getting this error
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.
how can fix this in query??