Brand New to qSql

Community Support
1

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

 

 

2

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

 

select from data where childID ~’ parentID

 

 

3

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