Concatenate two columns in Table Design

[niri77]

I have created a Table Design
Name
Last Name
ID Number
NameID

I import data from CSV xls file which has Columns of Name, Last Name, ID Number.

What I want to achieve is while importing it should Concatenate Name and ID number and store in Name ID.

I have searched it well but havent been able to find solution. Any suggestion how to achieve this.


Thanks
NIRI

 

[neileg]

This is denormalising your data. You should store the data in the normalised form. When you really need to concatentae, just use a query.

 

[niri77]

What I am trying to do is to do concatenate when i pull the data rather do it by query because. If I just pull the data, then I do query to concatenate create another table then do all my other queries...

so in a way i am trying to eliminate a step in between since i already need a concatenate values.

 

[neileg]

You are duplicating data. Don't.

 

[georgedwilkinson]

What I am trying to do is to do concatenate when i pull the data rather do it by query because. If I just pull the data, then I do query to concatenate create another table then do all my other queries...

This statement makes no sense. How do you get data if not by a query? Do you read the binary data from the disk and interpret it?

When you write the query to get the data (which you WILL have to do), just concatenate it then, as suggested earlier.