In a question about syntax, you should atleast specify the database system you are working upon. Syntax can vary.
On Jun 2, 7:19 am, isaac2004 <[email protected]> wrote: > hello, i am trying to implement a statement that creates a custom > column. here is the statement > > strSQL = > "SELECT FullMaster.nameFirst, FullMaster.nameLast, '[FullMaster]! > [nameFirst] & ' ' & [FullMaster]! [nameLast]' AS Expr1 FROM > FullMaster;"; > > what i am trying to do is concatenate two records and put them into > the new column. this will be used on a search results page that will > return a full name based on a partial or full name implemented > > Example > > if a user enters in Joe Bill, i want the results page to display that. > since i dont have a full name column to begin with, it does not work. > how do i get the expression into the string with the proper syntax. > thanks for the help
