Thanks for the replies. I've made it workin, but I wanna add something else:
So the question in SQL is: Maybe there is a way to hide columns it the result, like: SELECT car_nr, model, travel_days FROM table1,table2 WHERE number <> 414 AND (car_nr > truck_nr) from transport; and show only result of the colums travel_days, but ONLY on* **separate* columns and HIDE OTHER COLUMNS. I've posted here more detailed: http://forums.runrev.com/viewtopic.php?f=12&t=11426&p=53702#p53702 Help please... On 20 March 2012 01:09, Pete <p...@mollysrevenge.com> wrote: > Seems like either Peter or Mark's solution would be a lot better than > trying to do it with an SQL SELECT, but I'm also not sure of what Marek is > trying to achieve - seems strange to want to replace all the numbers with > plus signs. Maybe he wants a floating plus sign at the start of the > number, dunno. > Pete > > On Mon, Mar 19, 2012 at 3:50 PM, Peter M. Brigham, MD <pmb...@gmail.com > >wrote: > > > repeat with n = 1 to length(tInput) > > if char n of tInput is a number > > then put "+" into char n of tInput > > else put "-" into char n of tInput > > end repeat > > > > Or am I missing something? > > > > -- Peter > > > > Peter M. Brigham > > pmb...@gmail.com > > http://home.comcast.net/~pmbrig > > > > On Mar 19, 2012, at 5:15 PM, Pete wrote: > > > > > I wonder if there might be a less ugly way to do this in LC instead of > > > SQL... > > > Pete > > > > > > On Mon, Mar 19, 2012 at 2:04 PM, Marek <reichenbach.ma...@gmail.com> > > wrote: > > > > > >> Thanks a lot! That helped me a lot man. > > >> > > >> Marek Reichenbach > > >> > > >> On 2012 Kov. 19, at 19:29, Ken Ray <k...@sonsothunder.com> wrote: > > >> > > >>> > > >>> On Mar 19, 2012, at 3:44 AM, Marek Reichenbach wrote: > > >>>> when i get for example: 1234567 -> i should get result +++++++, > > 123-56- > > >> I > > >>>> would get +++-++- . > > >>> > > >>> The only way I know is kind of ugly, requiring seven nested REPLACE > > >> statements: > > >>> > > >>> SELECT > > >> > > > REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE("123-56-","1","+"),"2","+"),"3","+"),"4","+"),"5","+"),"6","+"),"7","+") > > >>> > > >>> This would return: > > >>> > > >>> +++-++- > > >>> > > >>> > > >>> Ken Ray > > >>> Sons of Thunder Software, Inc. > > >>> Email: k...@sonsothunder.com > > >>> Web Site: http://www.sonsothunder.com/ > > >>> > > >>> _______________________________________________ > > >>> use-livecode mailing list > > >>> use-livecode@lists.runrev.com > > >>> Please visit this url to subscribe, unsubscribe and manage your > > >> subscription preferences: > > >>> http://lists.runrev.com/mailman/listinfo/use-livecode > > >> > > >> _______________________________________________ > > >> use-livecode mailing list > > >> use-livecode@lists.runrev.com > > >> Please visit this url to subscribe, unsubscribe and manage your > > >> subscription preferences: > > >> http://lists.runrev.com/mailman/listinfo/use-livecode > > >> > > >> > > > > > > > > > -- > > > Pete > > > Molly's Revenge <http://www.mollysrevenge.com> > > > _______________________________________________ > > > use-livecode mailing list > > > use-livecode@lists.runrev.com > > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > > > -- > Pete > Molly's Revenge <http://www.mollysrevenge.com> > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
