Home › Forums › kdb+ › Brand New to qSql › Re: Brand New to qSql davidcrossey Member May 9, 2022 at 12:00 am If it’s not an exact match, you could wrap the second column in wildcards characters and use Like Each like' select from data where childID like’ (“*”,’parentID,'”*”) Note – this assumes that the parentID has less characters than childID