var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: This has to be easy but ...
How do i return numeric values from a list of numbers in a text column? To elaborate, here is the example:
i.e., when I go to ORDER BY price, I get results like this:
Is there an operator in MS-SQL that will allow me to simply return the
numeric value of a string? Why this price column was created as a text field I still don't know.
ORDER BY CAST(price AS numeric)
although I don't know what this will do to your overhead if you have more than 4 records
Cool - but what about the overhead
Hey it works great thanks!
Now, are there other data types that might reduce this overhead? Again, this column will only ever store numeric values. So, maybe DOUBLE or DECIMAL or something else might work better? I was searching for good SQL reference material but couldn't find it.
SQL reference? Books Online
see CAST and CONVERT
Thanks Rudy, a priceless resource. I've been there before but usually by way of links.
I think 'smallmoney' does what I need the best!