>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.
>


Kirk,

You can try idea suggested by George in Re: SQL Check Constraint for an Message #951548.