(Choose 1 answer)
You want to select author's last name from a table, but you only remember the author's last name starts with the letter B, which string pattern can you use?
A. SELECT lastname from author where lastname like 'B#'
B. SELECT lastname from author where lastname like 'B%'
C. SELECT lastname from author where lastname like 'B$'
D. None of the above