I need to create a query to determine if the value of the 4th character from the left is equal to 2 then update those that are not to 2. I am new at SQL and having a hard time locating this. Data is Access to SQL.
Field is Casenum
value is XX-200XXXX