Sorry, I hate to say it, but I don't think you actually have a customer just named 'Bayshore' . Check that you have the whole name. Here I do the same thing:-
SELECT * FROM Customer
and run a query for the first name
SELECT * FROM CUSTOMER where Name='Family Room'
However, this isn't uique and isn't indexed with a jump-in.
So, for the best results, always use FullName:
SELECT * FROM Customer where FullName='Abercrombie, Kristy:Family Room'
|