Brand New to qSql

[mkoon]

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

[SJT · Accepted solution]

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

select from data where childID ~' parentID

[SJT · Accepted solution]

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

select from data where childID ~' parentID

[davidcrossey · Accepted solution]

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