Is this something possible in SQL?
Select FirstName from Authors Where FirstName like 'MANNY%'
Right now i am getting:
but what i want is when the user types 'MANNY"
I want the query to pull the letters starting with
MANNYXXX, MANNY, MAN, MA, M etc....