@shubha1babu wrote:
Great!! Thanks a lot Tom.It worked.
But I need little more help.Need to compare two strings by first 5 alphabets.
e.g var1 var 2 match_parentage
marutix marutisyz 100
Thanks.
Use the SUBSTR function to select the first 5 characters from each variable.
result = complev(substr(var1,1,5), substr(var2,1,5));
... View more
