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