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: [email protected] [mailto:[email protected]] On Behalf Of
Claudine Robbins
Sent: Friday, October 26, 2018 3:08 PM
To: [email protected]
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:[email protected]
--
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].
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
