Re: Syntax for embedded sql

Insert into catable
> (member, namekey, namekey6, namekey10, name)
> Select substr(name, 1, 2, name, 1, 6, name, 1, 10)
> From Member
> Where members not = "0000000000"
> Order by Members
>EXEC-END.


If I have multiple substrings like above, can I place them in 1 set of
( ) or do them individually? Thank you for getting back with me so
quickly

.