Pulling a report for PO module

We recently migrated over to On Demand from Service desk Plus. My issue is I have a report that I pulled in Service Desk Plus that pulls the PO Number, the PO link and the PO Name - below is my sql statement

SELECT PURCHASEORDER.POCUSTOMID "PO Number", PURCHASEORDER.PONAME "PO Name", (' http://helpdesk.charmingcharlie.com:8080/PurchaseOrder.do?module=view&poID=' + CAST(PURCHASEORDER.PURCHASEORDERID AS VARCHAR)) "Link" FROM PURCHASEORDER

How do I do this query in On Demand

Thanks

Gunnar