MYSQL FUNCTION .str does not exist
代码如下：

SELECT a.intID, a.vhrCardNO AS 会员卡号, a.intMemberID, c.编码 AS 顾客编码, c.姓名, c.性别, c.身份证号, c.出生日期, c.生日, c.农历, c.联系电话, c.移动电话, c.地址, c.邮编, a.intCardTypeID, a.vhrCardTypeCode AS 会员卡类型编码, a.vhrCardTypeName AS 会员卡类型, a.decDiscount AS 折扣, a.decCredit AS 信用额度, a.intSaleType, case when a.intSaleType=1 then '金额' end,case when a.intSaleType=2 then '次卡' end AS 消费方式, a.decTimeMoney, a.decTimeRate, str(case when IsNull(a.decTimeMoney) then 0 else a.decTimeMoney end)+'元'+str(case when IsNull(a.decTimeRate) then 0 else a.decTimeRate end)+'次' AS 次数比, a.intTime AS 剩余次数, b.decJFRate AS 积分比, a.intStatus, case when a.intStatus=0 then '启用' else '停用' end AS 状态, a.vhrStatusReason AS 状态说明, a.txtRemark AS 备注, a.vhrCreateMan AS 创建人, a.dtmCreateTime AS 创建时间, a.vhrEditMan AS 修改人, a.dtmEditTime AS 修改时间, d.余额
FROM ((Member_CardInfo AS a LEFT JOIN member_CardType AS b ON a.intCardTypeID = b.intID) LEFT JOIN V_Member AS c ON a.intMemberID = c.intID) LEFT JOIN V_Member_Account_Balance AS d ON a.intID = d.intMemberCardID


我也不知道怎么回事、就是报错。str这个函数按理应该是可以用的。。。

------解决方案--------------------
没这函数啊