|
 |
access thread: Sorting in SQL
Message #1 by "Henry Napier" <hdh.napier@c...> on Tue, 17 Jul 2001 01:17:07
|
|
What critieria are needed to sort only the 4th and 5th digit,
ignoring first three.
eg. 03.74-01.78 (would like to sort ONLY 74)
Can anyone help please?
Henry
Message #2 by "Darron Michael" <darron.michael@h...> on Tue, 17 Jul 2001 13:49:16
|
|
In the query, create a separate field that is mid(textstring,4,2) where
textstring = 03.74-01.78
It doesn't have to be displayed but you can still sort on it.
HTH
8^)
Darron
> What critieria are needed to sort only the 4th and 5th digit,
> ignoring first three.
> eg. 03.74-01.78 (would like to sort ONLY 74)
> Can anyone help please?
> Henry
Message #3 by "Henry Napier" <hdh.napier@c...> on Tue, 17 Jul 2001 19:51:55
|
|
> In the query, create a separate field that is mid(textstring,4,2) where
> textstring = 03.74-01.78
> It doesn't have to be displayed but you can still sort on it.
> HTH
> 8^)
> Darron
>
> > What critieria are needed to sort only the 4th and 5th digit,
> > ignoring first three.
> > eg. 03.74-01.78 (would like to sort ONLY 74)
> > Can anyone help please?
> > Henry
Darron
Thank you for replying,
I've tried but it does not work.
Can you be more specific please?
Awaiting your reply
Henry
|
|
|
View Cart
