Ask Experts Questions for FREE Help !
Ask
    pumpkinslion's Avatar
    pumpkinslion Posts: 14, Reputation: 1
    New Member
    		  
    #1

    Jan 23, 2010, 12:34 PM
    vb
    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*"
    _Rab_'s Avatar
    _Rab_ Posts: 5, Reputation: 2
    New Member
    		  
    #2

    Feb 17, 2010, 05:07 AM

    The SQL you are looking for is :

    Select * from tblState where fldCapital like "S*"
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


View more questions Search