> I have something like A001C, B689, B1001 etc...
I had to do something like this, and someone suggested the following:
order by
case
when substring(YourField,1,1) between '0' and '9'
then ''
when substring(YourField,2,1) between '0' and '9'
then left(YourField,1)
I will give that a try.
Thank you
>>> Dan Nelson <[EMAIL PROTECTED]> 3/23/2004 11:31:50 AM >>>
In the last episode (Mar 23), Jacque Scott said:
> I have something like A001C, B689, B1001 etc...
Aah. This question pops up about once a year, usually under the
subject of "Natural Sorting". There's
In the last episode (Mar 23), Jacque Scott said:
> I have something like A001C, B689, B1001 etc...
Aah. This question pops up about once a year, usually under the
subject of "Natural Sorting". There's no builtin function for doing
this, but one solution would be to write a UDF that finds runs of
On Tue, 2004-03-23 at 09:54, Jacque Scott wrote:
> I need to create a query that will sort by a alpha numeric field. I
> need the ID field returned and one problem that I will face is that when
> it sorts in alpha numeric the ID field will be out of sequence. I will
> use this ID field in another
I have something like A001C, B689, B1001 etc...
>>> Dan Nelson <[EMAIL PROTECTED]> 3/23/2004 10:07:43 AM >>>
In the last episode (Mar 23), Jacque Scott said:
> I need to create a query that will sort by a alpha numeric field. I
> need the ID field returned and one problem that I will face is th
In the last episode (Mar 23), Jacque Scott said:
> I need to create a query that will sort by a alpha numeric field. I
> need the ID field returned and one problem that I will face is that when
> it sorts in alpha numeric the ID field will be out of sequence. I will
> use this ID field in another
I need to create a query that will sort by a alpha numeric field. I
need the ID field returned and one problem that I will face is that when
it sorts in alpha numeric the ID field will be out of sequence. I will
use this ID field in another part of the program so I need to make sure
I get all of