SQL: How to convert values to lower case and append an s?

Question

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

INSERT INTO TBL1 SELECT Col1.ToLower + 's'

FROM TBL2

Answer 1

INSERT INTO TBL1 SELECT LOWER(Col1) + 's'
FROM TBL2

Answer 2

Like this:

INSERT INTO TBL1 SELECT LOWER(Col1) + 's'
FROM TBL2 

Answer 3

INSERT INTO TBL1 SELECT Lower(Col1) + 's' FROM TBL2