David McDivitt <[EMAIL PROTECTED]> wrote:
> The database I'm reading has not been set up to collate without case.
> What functions are available? Is there a ucase or lcase such as:
>
>    ORDER BY UCASE(LastName)

order by LastName collate NOCASE;

Igor Tandetnik 



_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to