Click here to Skip to main content
15,885,278 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Please refer to this page for the background to this question.

1. if I write the query:

SELECT Surname FROM StaffRecord WHERE (Firstname = ' Danny ' AND Middlename = 'James';

will i get any result considering the fact that Surname, Firstname and Middlename are all stored as BLOB.

2. Which of the following queries is will you recommend:
(a)SELECT Surname FROM StaffRecord WHERE (Firstname = ' Danny ' AND Middlename = 'James';

(b) SELECT Surname FROM StaffRecord WHERE (Firstname LIKE ' Danny ' AND Middlename LIKE 'James';

considering the fact that Surname, Firstname and Middlename are all stored as BLOB.
Posted

1 solution

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900