How to only add values that end with 's'?

Question

I'd like to do this but I know this isn't the right syntax:

INSERT INTO TBL1
SELECT Col1    
FROM TBL2    
WHERE Col1.endswith('s')

Answer 1

INSERT INTO TBL1
SELECT Col1    
FROM TBL2    
WHERE col1 LIKE '%s'

where % works like * in wildcard and .+ in RegEx. It is SQL Server RegEx pattern indeed.

Answer 2

where substring(col1,LEN(col1)-1,1) = 's'

Answer 3

INSERT INTO TBL1 
SELECT Col1
FROM TBL2
WHERE Col1 LIKE '%s'

Answer 4

Insert Into TBL1
select Col1
from TBL2
where Col1 like '%s'

Answer 5

WHERE col1 like '%s'

% is the wildcard character which takes any value or any number of characters.

This site is good for learning this kind of thing: http://www.w3schools.com/sql/sql_like.asp