Copy value down a column

[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?

 

[KARL DEWEY]

Use an Update query.

 

[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?

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