Запрос на поиск по части слова

cursor.execute(select * from BUSINESS.V_PLATFORM_DDA where NAME = :jobno, {"jobno" : str(num)})

cursor.execute("""select * 
                   from BUSINESS.V_PLATFORM_DDA 
                   where NAME like '%'+:jobno+'%'""", 
                   {"jobno" : str(num)})

where NAME LIKE '%' || :jobno || '%'

query = """
    select * 
      from BUSINESS.V_PLATFORM_DDA 
     where NAME like '%{jobno}%'
    """.format(jobno=str(num))
cursor.execute(query)

column_name = "NAME"
query = """
    select * 
      from BUSINESS.V_PLATFORM_DDA 
     where {colname} like '%{jobno}%'
    """.format(jobno=str(num), colname=column_name)
cursor.execute(query)

table = BUSINESS.V_PLATFORM_DDA
"""select * 
    from {tabl1} # так можно?
    where Name like '%{jobno}%'""",
    format(jobno=str(num), tabl1=table)

table = 'BUSINESS.V_PLATFORM_DDA'
"""select * 
    from {tabl1} # так можно?
    where Name like LOWER('%{jobno}%')""",
    format(jobno=str(num), tabl1=table)

jobno=str(num).lower()

table = 'BUSINESS.V_PLATFORM_DDA'
"""select * 
    from {tabl1} # так можно?
    where LOWER(Name) like '%{jobno}%'""",
    format(jobno=str(num).lower(), tabl1=table)

where lower(Name) like '%\_{jobno}\_%'