Copy value down a column

M

mike

Hi,

I imported a .txt file with about 100k lines and column 1 has SSN and column
2 has the name and what I need to do is create a 3rd column and have every
cell in the 3rd column populate with "ES1"

How do i do that?
 
P

pietlinden

Hi,

I imported a .txt file with about 100k lines and column 1 has SSN and column
2 has the name and what I need to do is create a 3rd column and have every
cell in the 3rd column populate with "ES1"

How do i do that?
Click to expand...

SELECT SSN, Name, 'ES1' AS SomeColumnName
FROM MyTable
 
Top