Server: Msg 155, Level 15, State 1, Line 3 'mpinumber' is not a recognized OPTIMIZER LOCK HINTS option.When trying the following statement:
select patientid,rtrim(lastName)+', '+rtrim(FirstName) as PatientName,mpinumber from patients datalength(mpinumber) < 9 and datalength(mpinumber) > 0) and mpinumber is not nullI'm not sure what this means or how I should address it.