Code: Select all
id bid_no
200 AC634
200 AC455
The rule is :
if ids are equal , i need to check if their bid_nos start With AC but numerical is not equal .
In this case 634<>455.
Can we acheive this? If so how. Thanks...
Moderators: chulett, rschirm, roy
Code: Select all
id bid_no
200 AC634
200 AC455