Good Call Javier...
On Saturday, October 27, 2018 at 10:53:57 PM UTC-4, javier.valencia wrote: > > Claudine, > > > > Try the following: > > > > SELECT LISTOF('''' + your column + '''') into xxx from your_table WHERE … > > > > All the items should have single quotes and the comma should be inside the > quotes. > > > > Javier, > > > > Javier Valencia, PE > > O: 913-829-0888 > > H: 913-397-9605 > > C: 913-915-3137 > > > > *From:* rba...@googlegroups.com <javascript:> [mailto: > rba...@googlegroups.com <javascript:>] *On Behalf Of *Claudine Robbins > *Sent:* Friday, October 26, 2018 3:08 PM > *To:* rba...@googlegroups.com <javascript:> > *Subject:* [RBASE-L] - LISTOF question 10.0.4.10913 > > > > Hello all, > > > > My experience with LISTOF is that it automatically puts quotes around > fields that contain commas but I’m running into a situation where it does > not. > > > > One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the > space plus INC. as a separate value. > > > > However, it correctly returns 3 for the ITEMCNT variable. > > > > What am I overlooking? > > > > R>sho v vValueList > > YELLOW JACKET CONSTRUCTION, > > INC.,YELLOW JACKET > > OILFIELD,YELLOWHOUSE > > MACHINERY CO. > > > > [image: cid:image002.png@01D46D3C.007A56F0] > > -- > 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 rbase-l+u...@googlegroups.com <javascript:>. > For more options, visit https://groups.google.com/d/optout. > -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.