Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Can someone help me with my problem? I have a table consisting of LName C(20) GName C(20) Grade C(2)
> && Note: Grade contains mixed of Alpha and Numeric
>I am trying to sort my table using a function inside my Stored Procedure which will alphasort combining grade and name
>
>My function inside the Stored Proc goes like this:
>
>Function asort
> DO CASE
> case grade="1"
> nretval = 10
> case grade="2"
> nretval = 12
> case grade="3"
> nretval = 14
> case grade="1b"
> nretval = 20
> ENDCASE
> cOrder = ALLT(STR(nRetVal) + UPPER(ALLT(Lname)+ALLT(gName))
>RETURN cOrder
>
>I noticed that if u return an Character it wont sort properly but if u return a numeric the sorting goes well.
>Someone have an idea about This... Thanks. I reallt appreciate ur reply.
>
>
>
>This is only a sample table that i can come up.
this is the reason for bintoc()
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement