Never mind...I forgot the word WHERE :)

In SQL Analyizer i'm getting the following:

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 null

I'm not sure what this means or how I should address it.
If I put datalength(mpinumber) in the fields, and remove the where clause it works. But I need the where.

Thanks
Kirk