Convert AlphaNumeric to Numeric

[gowrishankar]

Hello,

I have to convert a alpha numeric value to a numeric value using query.
Is there a way to do it.

The column data type is Varchar and I am storing alpha numeric values to it.
I have to sort the column now. when I say order by [column name] it is not comming properly.

Need some solution to do it.

Regards,
GowriShankar.

[almaz]

Hello,

I have to convert a alpha numeric value to a numeric value using query.
Is there a way to do it.

The column data type is Varchar and I am storing alpha numeric values to it.
I have to sort the column now. when I say order by [column name] it is not comming properly.

Need some solution to do it.

Regards,
GowriShankar.

What do you mean by "alphanumer ic value"? Do you have non-numeric chars in the column? If yes, how do you expect it to be converted to numeric? If no, then use "convert(in t, ColumnName)" or "cast(ColumnNam e as int)" statements.
Please post examples

[Vijayshankarp]

What do you mean by "alphanumer ic value"? Do you have non-numeric chars in the column? If yes, how do you expect it to be converted to numeric? If no, then use "convert(in t, ColumnName)" or "cast(ColumnNam e as int)" statements.
Please post examples

try like this
SELECT Description
FROM ModuleSetup
ORDER BY CAST(Descriptio n AS varchar)