Wednesday, November 21, 2007

Concatanation in Sql-Query

Two different fields like firstname and lastname is shown together as one field by concatenating it in sql query.

SELECT CONCAT(contacts.FirstName, ' ', contacts.LastName) AS cn FROM contacts


It makes work more easier.

No comments: