I have a query to concatenate 3 fields "First Initial" + "Middle Initial" + "Last Name". Sometimes there is no middle initial but I need a space to be in its place but it just joins the “First Initial” + the “Last Name” together. Any suggestions?
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.