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