Jul-16-2020, 06:48 PM
Hi,
Anyone ever needed to do a partial key lookup in a dictionary?
By this for example I mean:
SELECT *
FROM EMPLOYEES E
WHERE E.NAME LIKE "DAR%"
/
Any suggestions as to how to achieve this efficiently?
Thanks
Gary
Anyone ever needed to do a partial key lookup in a dictionary?
By this for example I mean:
starting_key = myDict.getLike("Que*") while starting_key is not None: print(myDict[starting_key]) starting_key = starting_key.next()then iterate from any keys matching the "Que*" until there are no more matches. A bit like the following SQL query that uses a wildcard lookup:
SELECT *
FROM EMPLOYEES E
WHERE E.NAME LIKE "DAR%"
/
Any suggestions as to how to achieve this efficiently?
Thanks
Gary