1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

SQL: Why does 'S%' Die?

Discussion in 'C#' started by circuscircus, Jun 12, 2007.

Thread Status:
Not open for further replies.
  1. #1
    For some reason ANY any alphabet works EXCEPT S

    select * from tContact where UPPER(LASTNAME) LIKE 'A%' AND CONTACTSTATUSID = 1 ORDER BY LASTNAME ASC, FIRSTNAME ASC
    Code (markup):
    ^above works but once you put S in there, it dies

    (Does not work)
    select * from tContact where UPPER(LASTNAME) LIKE 'S%' AND CONTACTSTATUSID = 1 ORDER BY LASTNAME ASC, FIRSTNAME ASC
    Code (markup):
    Why is that? Is there a work-around?
    SEMrush
     
    circuscircus, Jun 12, 2007 IP
    SEMrush
  2. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,607
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #2
    like is not case senstitve, also, never do Select *

    Do:

    SELECT tContact.FieldName1, tContact.Fieldname2
    FROM tContact
    WHERE (LastName Like 'S%') AND (ContactStatusID = 1)
    ORDER BY LastName, FirstName
     
    ccoonen, Jun 12, 2007 IP
Thread Status:
Not open for further replies.