Nested SQL Replace
Infinity Development
dev at infinitydatasystems.com
Mon Dec 27 13:59:22 CST 2010
Never mind... I found my mistake.
Matt
dev at infinitydatasystems.com wrote:
> I seem to be having a problem with nested SQL Replace commands using
> the SQL method. Here's the select statement:
>
> "select replace( replace(subject, 're:', '') subject, 'fw:', '') As
> subject, RecID from tblEmails"
>
> As long as only 1 replace is used Valentina returns the results as
> expected. But with the nested select statement I get the following
> error:
>
> "line 1:45: expecting ')', found 'subject'"
>
> What am I doing wrong?
>
> Thanks
> Matt
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina
--
Sent from my Android phone with K-9 Mail. Please excuse my brevity.
More information about the Valentina
mailing list