Brand New to qSql

Just got started with qsql.

how to I compare 2 columns of type string.  childID and parentID are of type string

 

select from data where childID like parentID

 

 

If it’s an exact match you can use Match Each ~'.

 

select from data where childID ~’ parentID

 

 

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