Column sorting

[arijit]

I have a autogenerated column where i am displaying values like
205 [100,55,50]
120 [50,30,40]
506 [500,3,3]

Now, i want to sort the column on the first number (numeric sort), which is apperaing before the bracket.

Please help
Arijit

[Daniel]

Hello Arijit,

You can apply a custom sort criteria as shown in the following link:
Applying custom sort criteria

Then you can build a SQL expression that extracts the numeric part from this string and cast it to INT.

SELECT CAST( LEFT(ColumnName, CHARINDEX(' ', ColumnName)) AS INT) FROM MyTable

Regards,
Daniel
the Telerik team