I'm trying to get a count of records in a table where one field is not empty of null. The problem is that field is a text field and it I can't use the following:

Select count(procID) from coProc where coProc.isactive=1 and PatientInstr is not null and patientInstr > ' '

Anybody know another way, I tried datalength(patientInstr)>0 but that returned all rows.

Thanks

Kirk