which one of following commands allows you to select only records whose capital begins with the letter S?
select fldCapital= "S" from tblState
select * from tblState where fldCapital like "S%"
select* from tblState where fldCapital = "S%"
select* from tblState where fldCapital = "S*"

The SQL you are looking for is :

Select * from tblState where fldCapital like "S*"