Sorting dollar values in a grid field

I have a grid field with text columns. The values populating these fields are pulled from a stored procedure. In the database the values are stored as decimals. I am having problem with sorting the column.

OriginalPostID-256453



  Discussion posts and replies are publicly visible