2 questions.

Is there a strlen function in sql?

Can you do a multiple comparison on the same field.  I would like to be
able to find entries that have either a null entry or a blank entry as a
boolean result and sort by the boolean result.

(ie: select field='' or field is null as x from table order by x;)

The above statement core dumps.  The current solution is to:

update table set field='' where field is null; 

before running the query.  There must be a better way?  Ideas?

Thadvancenks!!!!

--
Colin Dick
On Call Internet Services
cdick@mail.ocis.net