Do you know how to get nameFirst and nameLast into a string to use in an asp.net file? If so, do the same logic, the column name instead of nameFirst is FullName if you use the SQL I posted previously.
On Jun 3, 1:37 pm, isaac2004 <[email protected]> wrote: > i know that, but how do you get it into a string to use in an asp.net > file > > On Jun 3, 7:07 am, The_Fruitman <[email protected]> wrote: > > > > > SELECT nameFirst, nameLast, nameFirst & " " & nameLast as FullName > > FROM FullMaster > > > On Jun 2, 12:56 pm, isaac2004 <[email protected]> wrote: > > > > the database i have is an access database with about 6 tables in it. > > > The table that I want to grab stuff out of is called FullMaster, and I > > > want the columns Fullmaster.nameFirst and FullMaster.nameLast, as well > > > as the custom column to be generated in the select command, or in > > > Access it would be Fullmaster.nameFirst & " " & > > > Fullmaster.nameLast. thanks for the help > > > > On Jun 1, 10:54 pm, Cerebrus <[email protected]> wrote: > > > > > 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- Hide quoted text - > > > > - Show quoted text -- Hide quoted text - > > - Show quoted text -
