SQL

Question

I am new to SQL. I am writing a script to select all last names in database student that ends with upper case T
And is at least 3 characters long in length. I know for upper case letter is
SELECT * FROM Student
WHERE StudentLastName LIKE ‘%S’;
But what about length?
Please help!

Answer 1

Knowledge Is Power

You can use len function

len(name) >= 3

Answer 2

Knowledge Is Power

In Feed Posts

Answer 3

Knowledge Is Power

Do you see Posts in your profile?

Answer 4

Got it A͢J I just posted there. Thank you👍

Answer 5

Hey. Use
SELECT * FROM STUDENT WHERE STUDENTLASTNAME LIKE ‘%T’

To get the data that ends with T

Answer 6

A͢J Do you how can i share ERD diagram at Sololearn?

Answer 7

A͢J where is feed post. I see Q&A and code playground. Where is feed post?

Answer 8

The ? symbol can be used as a wildcard placeholder that represents 1 unknown character. Change the LIKE clause to look like this:

StudentLastName LIKE '%??T'