how to make Two Column Values as One Column Value

Hi Friends

Sorry for Posting this particular Question Here, Acually this is not related to java, I know, But i am really in need of your help on this Issue. and also can get an immediate solution on this Forum. so that i am posting here. Please pardon me

My problem is I hava a Database table having three FieldsStaff_ID, First_Name, Second_Name.. Here there 3000 records in this Table. Now i want to make these to First_ Name and Second_Name AS a One FieldName. That is i want these two Field's value into one Field.

Please help me to come out of this Problem

Thank you for your service

Cheers

Jofin

[660 byte] By [jofin123a] at [2007-11-27 2:34:51]

«« java script
»» Store ID in ComboBox

# 1

I don't know which database you're talking about, but it is sufficient to search in the database-specific SQL documentation using the keyword "concat".

BalusCa at 2007-7-12 2:52:39 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

Hi Thank you for your Reply, I am Using Ms-Access Database,Thank you for your serviceCheersJofin

jofin123a at 2007-7-12 2:52:39 >

# 3

Probably it's the + operator. It is in SQL Server, so I suspec it's the same for Access (not sure if this is standard SQL or not).E.g. select foo + ' ' + bar as foobar from tblFubar where id = 42;

dcmintera at 2007-7-12 2:52:39 >

Database Connectivity

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

how to make Two Column Values as One Column Value

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified