CODEWITHSUNDEEP
sql-server-2008
wil
wil

Reputation: 77

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:

INSERT INTO
               TBL1 SELECT 
               Col1.ToLower + 's'
FROM
               TBL2

Upvotes: 5

Views: 14853

Answers (3)

Charles Bretana
Charles Bretana

Reputation: 146499

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

Upvotes: 3

SLaks
SLaks

Reputation: 887469

Like this:

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

Upvotes: 4

Lucero
Lucero

Reputation: 60190

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

Upvotes: 21

Related Questions