Home Forums Job & Work Life SQL 간단한거 답변해주실뿐? This topic has [6] replies, 0 voices, and was last updated 7 years ago by sssss. Now Editing “SQL 간단한거 답변해주실뿐?” Name * Password * Email Topic Title (Maximum Length 80) 안녕하세요 SQL공부중인데 이럴경우는 어떻게 query하나요? 예를 들어 Find all First name whose first name starts with A and 이런식으면 Select * FROM Employees WHERE FirstName LIKE %A 근데 만약에 Find all names that have only four characters in either first or last name? Substring(FirstName, 1, 4)이런거는 FirstName에서 1번부터 4번째자리만 주는거고 First나 Last Name character자체가 4글자인것들은 어떤식으로 찾아야하나요? I agree to the terms of service Update List
