Converting Functions from MSSQL to MYSQL

[M B]

Hello,

I've been working on converting functions in MSSQL to MYSQL and I've run into a bit of a issue. Below is my current function code for MYSQL that I've converted from MSSSQL. I may be looking at this in the wrong way..Can any provide me any insight on what I'm doing wrong. I'm currently getting a syntax error after RETURN.


DELIMITER
ALTER FUNCTION dbo.qfSo

RETURN SELECT tblServiceOrder.AccountNumber, tblServiceOrder.DateBilled, tblServiceOrder.AmountDue, tblServiceOrder.Balance,
tblServiceOrder.SoNumber, DATEDIFF(d, tblServiceOrder.DateBilled, ISNULL(tblServiceOrder.DatePaid, vNow.Now)) AS PayRate,
tblServiceOrder.DatePaid, vNow.Now
FROM dtblServiceOrder CROSS JOIN
vNow

Thank you in advance for your help.