query of query not sorting properly

[chedderslam777]

I am using query of query to run against a product search using verity.  I have sort buttons that can sort the results by name or price, asc and desc.  When sorting by price, it is not sorting properly.  Here is an example:

$110.00

$110.00

$115.00

$124.00

$24.00

$36.00

$40.00

And so on.  What is going on?  Is there any way to fix this?  Thanks.

[Dave Ferguson]

This is sorting properly.  It is sorting as a string.  To get it to sort numerically you need to convert it to a number.

[chedderslam777]

Thank you for the help.  I did not know this.  How would I go about converting it?  I have tried both a cast function from TSQL and a LSParseNumber(string) function from ColdFusion, but neither work.  I'm not sure what to do.

[haxtbh]

Whats the database field type? What code have you tried already?