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

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

INSE开发者_如何学CRT INTO
               TBL1 SELECT 
               Col1.ToLower + 's'
FROM
               TBL2

---

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

---

Like this:

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

---

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