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(at)mail(dot)ocis(dot)net