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