Solving crossword puzzles in SQL practice

SELECT *  from Dbo.spt_values

Suppose we need to find words that have the following characteristics:

(1) Second letter: a

(2) Fourth letter: L

(3) A word with only 5 letters

The code is as follows:

SELECT name  from dbo.spt_values WHERE  like'_a_l_'

2. Change the requirements below

Find the first three letters and the last three letters of words in the Word table, the following is the solution code:

SELECT name  from dbo.spt_values WHERE  like'%'+SUBSTRING(name,1,3 )+"andLEN(name)>3

OK, solve the demand!

Solving crossword Puzzles for SQL practice