The result of concatenating two character strings is. The concatenation operator is two. Versions of Oracle Database. To concatenate an. MySQL Functions SQL Server Functions MS Access Functions Oracle. SQL Server Concat With + SQL. The + operator allows you to concatenate two or more strings.

The SQL behind the query should read SELECT [Title] & ' ' & [ForeName] & ' ' & [Surname] AS WholeName FROM Details; To do it in the design grid: Type the new field name followed by a colon then type the first name of the field followed by the &, then 2 double quotes with a space between them, followed by the second field name etc. Stewart 'C L Humphreys' wrote in message news:bk**********@ucsnew1.ncl.ac.uk. Hi, I would like a sql query that would return the results of 3 selections as one column. For example I may have select title, forename, surname from details; but would like the results in one column, with the fields concatenated (with a space preferable between!) This should be simple, right?:) Thanks, Chris. Alternate: SELECT Title + ' ' & Forename & ' ' & Surname) AS FullName FROM details; Works great for middle names!

Tim Mills-Groninger 'Allen Browne' wrote in message news:Xs********************@news-server.bigpond.net.au. SELECT Trim(Title & ' ' & Forename & ' ' & Surname) AS FullName FROM details; -- Allen Browne - Microsoft MVP.

Perth, Western Australia. Patches For Boss Gt 100 Manual Pdf. Tips for Access users - 'C L Humphreys' wrote in message news:bk**********@ucsnew1.ncl.ac.uk. Hi, I would like a sql query that would return the results of 3 selections as one column.

For example I may have select title, forename, surname from details; but would like the results in one column, with the fields concatenated (with a space preferable between! Duffy Warwick Avenue Midi For Synthesia. ).