How Can I format in SQL

[aamer]

I want to format the following in SQL



SELECT [000005King].PurCoId, [000005King].PurCompanyName, [000005King].SumOfBalAmt, [000005King].TrueBal
FROM 000005King;


I want the following to Show as Rs. Not $

[000005King].SumOfBalAmt
[000005King].TrueBal

I don't know how to fit "Rs. "#,##0.00;"(Rs."#,##0.00) in the above SQL statement.

[ranman256]

What is RS?
anyway, in the query,right click the field, Format, set how you want.

[aamer]

Rs is Rupees (currency)

I know how to do in query but this was a part of union query. Following is the complete union query.

SELECT [000006CCBPL].PurCoId, [000006CCBPL].PurCompanyName, [000006CCBPL].CCBPLBal, [000006CCBPL].TrueBal
FROM 000006CCBPL;
UNION ALL SELECT [000005King].PurCoId, [000005King].PurCompanyName, [000005King].SumOfBalAmt, [000005King].TrueBal
FROM 000005King;

[John_G]

Make another query based on your union query, and format the data there.