Hi Chris,

Chris Short wrote:
What does your SQL statement look like?

very simple:

SELECT value, period
FROM relevant table
WHERE (identifier = X) or (identifier = Y) or etc
ORDER BY period

You could try a CAST on the value column - I'm assuming that's the one that
comes back as a string value? If all values within that column will be
numeric, you could do this:

SELECT CAST(value AS decimal(18,4)), period
FROM relevant table
WHERE (identifier = X) or (identifier = Y) or etc
ORDER BY period

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]