strCmp (Compare Two Strings)
info("int strCmp(str text1, str text2)");
info("Compares two text strings. The function is case-sensitive.");
info("0 if the two strings are identical, 1 if the first string is longer, or -1 if the second string is longer.");
info("e.g.");
info("strCmp(\"abc\",\"abc\") = " + int2str(strCmp("abc","abc")));
info("strCmp(\"ABC\",strUpr(\"abc\")) = " + int2str(strCmp("ABC",strUpr("abc"))));
info("strCmp(strLwr(\"ABC\"),\"abc\") = " + int2str(strCmp(strLwr("ABC"),"abc")));
Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole...