The name format is "lastname, firstname"<BR>I try to use Substring() function to do a search by lastname but I don't get the right records returned. Please help. Thank you
ok quick and fuzzy but will work <BR><BR>Select ... From <table> where Name like '" & valeoflastname & ",%'"
Thanks, I'll try it