Here is the main query. You can see in my where clause I use two functions. Code for the functions is below. SELECT GSV_RSVLDGR_V.ASSET_NUMBER , GSV_RSVLDGR_V.DESCRIPTION , GSV_RSVLDGR_V.DATE_PLACED_IN_SERVICE , GSV_RSVLDGR_V.MAJOR_CATEGORY , GSV_RSVLDGR_V.COMPANY , GSV_RSVLDGR_V.DEPARTMENT ,…