I have a program which accepts inputs from the user on the screen.Accordingly it would display.
Problem - User enters CHRIS(only accepts capital). When user hits enter it is displaying insured name starting with CHRIS only. Though database is having both CHRIS and Chris. Is there any built-in-functions to trap both CHRIS and Chris and that too sequentially.Means - Chris Smith should appear befor CHRIS William.
Appreciate your help.
Thanks & Regards
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!