Are wildcards allowed when trying to matchthe contents of a textfield as in the following example?
SELECT * FROM Database WHERE textfield = ‘B*’
Yes, but you’ll need to use the LIKE clause instead ofthe equal sign, and the wildcard character in SQL is thepercent sign. Your correct syntax will be:
SELECT * FROM Database WHERE textfield LIKE ‘B%’;