Microsoft
MB6-890 · Question #8
Your solution stores customers in a table named Gust Table. CustTable contains a field named AccountNum, which is used to store the unique account number for a customer. Data in the AccountNum field…
The correct answer is D. select * from CustTable where CustTable.AccountNum like "?H*". See the full explanation below for the reasoning.
Question
Your solution stores customers in a table named Gust Table. CustTable contains a field named AccountNum, which is used to store the unique account number for a customer. Data in the AccountNum field is 4 characters in length. You need to retrieve only the records in CustTable where the second character of the Account Number is the letter "H". How should you write the select statement?
Options
- Aselect * from CustTable where CustTable.AccountNum like "*H"
- Bselect * from CustTable where CustTable.AccountNum like "*H?"
- Cselect * from CustTable where CustTable.AccountNum like "H*"
- Dselect * from CustTable where CustTable.AccountNum like "?H*"
How the community answered
(24 responses)- A4% (1)
- B13% (3)
- C4% (1)
- D79% (19)
Community Discussion
No community discussion yet for this question.