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?
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