Post reply

select * from tbl where like is all

  • September 2, 2011 at 12:47 pm

    #149579

    I will like the sql statement to extract all the records

    like select * from tbl where a like what ever . thanks.

  • September 2, 2011 at 12:50 pm

    #1376642

    A straight SELECT * FROM <table> will return all columns, all rows.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 2, 2011 at 12:53 pm

    #1376644

    I will like to simply the other thing. It is hard to explain the whole intention of my coding. Thx.

    That is the reason. ..

  • September 2, 2011 at 12:55 pm

    #1376645

    Frances L (9/2/2011)

    I will like to simply the other thing.

    What 'other thing'?

    It is hard to explain the whole intention of my coding.

    If you can't explain it, how do you expect someone to help you?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply