You could do:
SELECT quantity::text FROM tblOrders
On 05/05/2009, at 8:21 AM, JORGE MALDONADO wrote:
> Is it possible to convert a numeric value to string within a SELECT
> query statement?
> For example, let's say that I have a table with a numeric field
> named "quantity". A normal SELECT would be "SELECT quantity FROM
> tblOrders". What if I want the value returned by the SELECT clause
> to be of type string instead of decimal?
>
> Regards,
> Jorge Maldonado