Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In a table,I have two fields A
and B
. I have to retrieve those rows where A<>B
. The problem isA
could be '12|14|15'
and B
could be '12|15|14'
. So, they are actually same , only that the order of numbers is different. How do I retrieve rows where the fields are really not equal ,like'30|31|14'
and '31|30|15'
, or '22|23'
and '22' ?
Thanks,
Anju
HI
May be try like this
Hi
May be its give solution for you, but not sure..
Split the column by using SubField() function.
Then by use order by concatenate it by using concat() function, after that check it.
can you provide some sample scripts please?
HI
May be try like this
Thank You!
This would solve my problem.
Hi Mayil,
After I have been able to find unequal strings.. and I have , say 2 fields A and B,
where A is say '12|13|15' and B is '15|12|14' can I have have 2 more fields like 'In A not in B '='13' and 'In B not in A'='14'.
Thanks,
Anju
Hi,
I hope the attachment will help you
Thank you, Celambarasan!