You can indeed combine select output with literal text on the same line. >From RRBYW20:
select (ContFName &ContLName )=40 ,'This is some literal text'=50 from contact where limit = 10 shows: Jill Baileys This is some literal text Shelley Watts This is some literal text Andy Chin This is some literal text Bill Jones This is some literal text Betty Jones This is some literal text Sharon Brady This is some literal text Anna Adams This is some literal text Nancy Allen This is some literal text Dennis Berger This is some literal text George Clifton This is some literal text WhereAs: select 'This is some literal text'=50, (ContFName &ContLName )=40 from contact where limit = 10 shows: This is some literal text Jill Baileys This is some literal text Shelley Watts This is some literal text Andy Chin This is some literal text Bill Jones This is some literal text Betty Jones This is some literal text Sharon Brady This is some literal text Anna Adams This is some literal text Nancy Allen This is some literal text Dennis Berger This is some literal text George Clifton On Friday, May 1, 2020 at 4:50:29 PM UTC-4, Jim McPherson wrote: > > All, > > > > We keep a list of files in our database and I am looking to copy a select > few to a different location as part of the programming. I’ve sorted out > the SELECT statement. Can that be used as a source file location? If so, > what’s the syntax? > > > > Here’s what I’m trying: > > COPY (SELECT FileNameLocation FROM Table WHERE CustomerID IN > &vCustomerList) &vDirectoryFileName > > > > I’m also open to any other ways to accomplish the task. > > > > Thanks, > > > > Jim > > > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/397a377a-ca02-4f09-b4f4-f7f4540e5d97%40googlegroups.com.
