Brand New to qSql

Community Support
,
1

https://learninghub.kx.com/forums/topic/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

 

 

2

If its 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