select ownerId, ownerType, ftpServer, ftpUserName, ftpPassword, ftpDirectory, connectionName from tbl_EAI_inboundFTPSources where ownerId = 709 and ownerType = 'MFR' and outbound = 'Y' and connectionName like 'MFR_SALES_DATA_EXPORT BROKER:%' select * from tbl_EAI_inboundFTPSources where ownerId = 387 and ownerType = 'BRO' and outbound = 'Y' and connectionName like 'se-staging-affinity%'