View Full Version : String Handling in QRY
01-01-1995, 02:00 AM
On Sunday, January 24, 1999, 10:11 AM, Bill Adams wrote: Is there any way in defining a results field to do the equivalent of CL's FLDA *BCAT FLDB and RPG's FLDA CAT FLDB:1? Bill Adams <hr> Are you using Query/400? If you are, and the fields in question are character fields, the answer is yes. On the screen to define fields you can concatenate using two vertical lines (sorry no vertical line symbol on my PC keyboard - so I will use exclamation points instead) FLDA !! FLDB will get you the desired result. David Abramowitz
01-26-1999, 03:49 AM
I don't know if they fit in your situation , but REXX and SQL arefar more adapted to "string" problems than RPG,CL and any of itscommands......... <pre> <H4>Bob Hamilton TEXAS BUSINESS SYSTEMS 736 Pinehurst Richardson, Texas 75080 <h4> </pre></h4></h4>
01-26-1999, 06:20 AM
Bill, I tried one thing that would have made sense but it doesn't work. In CL you can use the || (which is what Query uses as you know) as concatenate instead of *cat. In CL you can also use |> instead of *bcat. So... I tried |> and it isn't allowed. So I guess you won't be able to do what you want. Bill Bill Adams wrote: I know you can concatenate character fields but I wanr to remove all but one of the trailing blanks in FIELDA, which is what *BCAT does in CL. . .
01-27-1999, 02:48 PM
<a target=_new > href="http://www.dejanews.com/getdoc.xp?AN=434513666">http://www.dejanews.com/g etdoc.xp?AN=434513666</a> Regards, Chuck Comments provided "as is" with no warranties of any kind whatsoever.
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.