Re: Sorting a string of numbers ?

2007-06-12 Thread Jarl Grøneng
Did a similar thing with grouplist, but returned it as a table, Then I created a view form against it and could be used as a add remove table to maintain groups a user is member of. (was done in Oracle) -- Jarl On 6/12/07, Tim Widowfield <[EMAIL PROTECTED]> wrote: This is the sort of thing th

Re: Sorting a string of numbers ?

2007-06-12 Thread Tim Widowfield
This is the sort of thing that's probably best done at the database level with TransactSQL, but just for fun I wrote up a JScript script. Here's the gist of it: var args = WScript.Arguments; var tempArray = new Array(); var inputString, outputString = "";

Sorting a string of numbers ?

2007-06-12 Thread Carnevali, Carol x23849
Does anyone know how to sort a string of numbers that exist in a character field? For example: 010 007 004 030 029 I would want this to sort as: 004 007 010 029 030 Thanks! Carol ARS 7.0.1 patch 2 SQL 2000 This message and any attachments are intended only for the use of the addressee and