At 03:48 PM 15/03/2009, you wrote:

>I use ASC as in the following without any problems-
>
>Location_DataTable.Select(
>
>"LOCATION >= '0'",// don't deal with video server - hirarchy '0'
>
>"LOCATION ASC");
>
>I can't however use DSC and it always fail.

What are you actually talking about here "ASC" and "DSC"???

Something to do with ASCending and DESCending indexes, perhaps? If so, note that the SQL short form of DESCENDING is DESC, not DSC...

./heLen