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: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Friday, October 26, 2018 3:08 PM To: rbase-l@googlegroups.com 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. 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+unsubscr...@googlegroups.com. 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.