There was a similar question recently where the backend was PostgreSQL and it's syntax was slightly different. Translating Andrew's SELECT, would become:
SELECT `FirstName` || ' ' || `LastName` AS 'Name' FROM `Customers` There was a suspicion that this was standard SQL syntax, but nobody was sure. But the 'Run SQL Direct' was the key. On Thu, 2006-02-09 at 16:58 -0700, Shane Johnson wrote: > Thank you Drew. I will give that a try. Will have have to build the > whole query with SQL or can I just do the column I need to modify? > > Thanks > Shane > > > Andrew Jensen wrote: > > > Hi shane, > > > > Using OO 2.0.1 on WinXp and connecting to a MS Access database I can > > perform a cancatination such as this: > > SELECT `FirstName` & ' ' & `LastName` AS 'Name' FROM `Customers` > > `Customers` > > > > You must run this query as 'Run SQL Direct', which in the Query > > builder is the button with a green check mark over the letters SQL. > > > > HTH > > > > Drew > > > > Shane Johnson wrote: > > > >> Good Afternoon. I was referred here from the OOo users group. > >> The following is a paste of the message I sent to that list. If > >> anyone can help me I would appreciate it. > >> > >> Thank you > >> Shane > >> > >> > >>> I am converting from Access to Openoffice and was trying to run a > >>> query > >>> against a ODBC source. In Access I could do something like the > >>> following > >>> > >>> fieldname: [table:Data1] + [table:Data2} > >>> > >>> and have it spit out a concatenated result. I tried this in Base > >>> and it > >>> will not let me do this. Did I miss something or is there a different > >>> way to do this. > >>> > >>> I am running 2.0.1 on Win2K.(Let me know if you need more info) > >>> > >>> I went through the how-to on Base and it didn't really help. If there > >>> is some other resource you could point me to that I couldn't find, > >>> that > >>> would be appreciated as well. > >> > >> > >> > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > >> > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
