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