CAST as CHAR on multiple records

[David Donahue]

I have a SELECT statement which casts a Text field to Char (for proper conversion in the software that calls it):

SELECT
Website_Rants.RID RID,
Website_Rants.Title Title,
CAST(Website_Rants.Body AS CHAR) Body,
Website_Rants.Date Date,
COUNT(Website_RantComments.RCID) Comments
FROM
Website_Rants
LEFT OUTER JOIN Website_RantComments ON Website_Rants.RID = Website_RantComments.RID
GROUP BY
Website_Rants.RID

Now, when there is only 1 record in the resulting data, the conversion works fine. But when more than 1 record is returned, the cast doesn't seem to work and the field is still of type Text. Am I doing something wrong? How can I make this work on every record that is returned? Is there a better way to accomplish this?


Regards,
David P. Donahue
[e-mail]