Try SELECT LASTNAME FROM PERSONLIST ORDER BY UPPER(LASTNAME)
But questions like this belong to the firebird-support group, not the
jaybird group.


Am 03.08.2004 1:47 Uhr schrieb "maxtelfer" unter <maxtelfer@...>:

> Is there a character set where a
> SELECT LastName from PersonList ORDER BY LastName
> would give a result that is not case dependent?
>
> eg, I get
> Adams
> Harris
> d'Azzo
>
> where I would like to get
> Adams
> d'Azzo
> Harris
>
> I am using Jaybird.
>
> Regards
> Max
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
> <http://us.ard.yahoo.com/SIG=1293ou6o0/M=295196.4901138.6071305.3001176/D=grou
> ps/S=1705006764:HM/EXP=1091576884/A=2128215/R=0/SIG=10se96mf6/*http://companio
> n.yahoo.com>
>
>
> Yahoo! Groups Links
> * To visit your group on the web, go to:
> * http://groups.yahoo.com/group/Firebird-Java/
> *
> * To unsubscribe from this group, send an email to:
> * Firebird-Java-unsubscribe@yahoogroups.com
> <mailto:Firebird-Java-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> *
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>

--
_ _ _
)) _ __ ___ ))_ ___ __ __))
((_)((_( (| ((_( ((`( ((_( (| ((_(
_))
http://www.news.cornell.edu/releases/July97/guitar.ltb.html



[Non-text portions of this message have been removed]